Preventing other mdb files from Importing table objects

  • Thread starter Thread starter Paul Ponzelli
  • Start date Start date
P

Paul Ponzelli

Is there any way to protect an mdb file (in Access 2002) so that other users
in other mdb files can't import tables from it, or even link to its tables?

Thanks in advacne,

Paul
 
Sure, don't give them access to the tables. Implement user-level security
and take away all access to the tables. Base all your forms and reports on
stored queries that are set to "run with owner permission".

This will prevent users from getting to your tables, but will still allow
them to see/modify data in your forms and reports.
 
It's starting to look like I can't avoid using Access security any longer.

Thanks, Rick.
 
Back
Top