Open the backend MDB database

[Huayang]

I set the password for the backend MDB database.
how to link tables in the backend MDB from frontend? Thanks

 

[Chris Mills]

I set the password for the backend MDB database.

how to link tables in the backend MDB from frontend? Thanks

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

 

[Huayang]

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.

 

[Chris Mills]

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

 

[TC]

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