Open the backend MDB database

  • Thread starter Thread starter Huayang
  • Start date Start date
H

Huayang

I set the password for the backend MDB database.
how to link tables in the backend MDB from frontend? Thanks
 
I set the password for the backend MDB database.
how to link tables in the backend MDB from frontend? Thanks
Click to expand...
If you mean the "database password" prevents you doing this, you should be
using "User Level Security" and setting the exact same security/Users on both
the frontend and the backend. That way, your frontend has permission to use
the backend!

Chris
 
I only open the backend MDB database using the following:

Set MyDB = OpenDatabase(DataFileName, , , "driver={Microsoft Access Driver
(*.mdb)};Pwd=123456")

but it doesn't work.
 
I don't see in any Help sample on Opendatabase where you would use
"driver={Microsoft Access Driver
(*.mdb)".

(Start simple by using the example of opening Northwind...)

Chris
 
Try:

set MyDB = DBENGINE.OpenDatabase(DataFileName, False, False,
";PWD=s3cr3t")

Note: when you use methods of the dbengine object - eg. opendatabase -
you should always include the dbengine keyword, as shown above.
Otherwise, strange DAO licencing & other errors can occur; for example,
the inability to create an MDE in certain cases.

HTH,
TC
 
Back
Top