How to link to secure access database without prompting user for datab

[BlueTube]

Hi all,
I’m trying to link to a table in a secure access database from another access database. However, I don’t want the user to be prompted for a password when I link, is there is a way to do this in vba? I’m using DoCmd.TransferDatabase acLink to link to the secure access database table and I want to insert/update some records then I want to deleted the linked table.

 

[lameid]

If you mean secure as with Access Security, give the admin user (default user) read design and read data permission in the source database. Then Everyone can read the data.

Otherwise I would look at the option of using ODBC in transfer database... check out the following URL for connection strings.

http://www.connectionstrings.com/access

I think you want the one headed With database password.

The catch here is you will have to save the password in code. This is generally not a good idea.

 

[BlueTube]

Thanks for your help lameid but I don't think that I can "link" a table using ODBC, I get an error. I don't want to use ado.connection object I was hoping that I can just link to a table using the DoCmd.TransferDatabase acLink or any other method that will get the same result (a linked table in the tables clolection). any thoughts?