Preventing other mdb files from Importing table objects

[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

 

[Rick B]

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.

 

[Paul Ponzelli]

It's starting to look like I can't avoid using Access security any longer.

Thanks, Rick.