Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Prevent External Queries

Author  Topic 

Billkamm
Posting Yak Master

124 Posts

Posted - 2006-03-07 : 11:20:37
How can you prevent external queries of a non-password protected Access database?

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2006-03-07 : 11:38:11
The easiest way is to be sure the MDB file is somewhere secure on the network. If they can't get to the MDB file, they can't link to one of your tables.

You can also use Access JET workgroup security to secure tables.

Otherwise, you will need to be more specific as to what you want.
Go to Top of Page
   

- Advertisement -