Change\handle passwords on linked tables

[amir369]

How do I supply the correct password to a linked tables?
I've created a database with linked tables. The database with the originals
tables, which is password protected is on a server and the file with the
linked tables is on the user's side. Now, how do I supply or change the
password when it's needed?

 

[Arvin Meyer MVP]

Use the same workgroup to create both files. Or for even better security,
allow no permissions on the server tables except for the owner of those
tables, then on the user side, access the data only through
OWNERACCESSOPTION queries.

 

[amir369]

I'm not using workgruo security. only database file protection. All I need to
know how do I maintain this passwords.

 

[Arvin Meyer [MVP]]

The Security Model changed with the newest Access 2007 format (accdb) and is
different from the mdb format. My experience is with full Access security in
the mdb format. I suggest you re-ask this question in the security
newsgroup, and be specific as to which format and version of Access that you
are using.