linking to password protected DB

[22strider]

Hello Friends

Is it possible to allow linking to a password protected Access database?

I am maintaining a database in Access 2007 that I want to protect by a password so that nobody can change tables etc. At the same time I want other users to be able to link to those tables without giving out password to them

Thanks
Rajesh

 

[SydneyGeek]

If you mean linking via another Access database, you can do that by breaking the links, then relinking. You will need to provide the password when you relink. Then give people that database to use and they will have access to the data without being abe to touch the table design.

If you want to let people link using Excel you have more of a problem. It is possible to link using ADO or DAO code, but you will then need to password protect the Excel VBA project, otherwise they can get the Access password in the connection string.

Denis