I've not able to get aspdb to work with a secured Access database. We've been using DNS-less connection and attempted to get aspdb to work after we secured the database.
I've tried:
MyDb.DbDNS="Driver={Microsoft Access Driver (*.mdb)};UID=userxxx;PWD=123456;DBQ=C:Inetpubwwwro otDATANEW DEMO.MDB;SystemDB=c:inetpubwwwrootDATAsecured.mdw& #34;
and
MyDb.Dbmdb = "C:InetpubwwwrootDATANEW DEMO.MDB;User ID=userxxx;Password=123456;SystemDB=c:inetpubwwwro otDATAsecured.mdw"
and creating a system DSN and calling aspdb:
MyDb.dbDSN = "DSN=1DemoLaptop"
which does specify the system database (secured.mdw with username and password)
This works for:
Set conData = Server.CreateObject("ADODB.Connection"
conData.ConnectionString="Provider=Microsoft.J et.OLEDB.4.0;Data Source=C:InetpubwwwrootDATANEW DEMO.MDB;User ID=userxxx;Password=123456;Jet OLEDB:System Database=c:inetpubwwwrootDATAsecured.mdw"
What am I doing wrong.