Hi,

I'd like to protect all the tables in my database so that no one can open
and look at the tables. What I did is the following
1. in my form, I set it "modal".
2. I set all of my tables hidden.
3. I convert the database to .mde.

Is this enough to protect the tables?

Thanks,
Boon

None of that will keep anybody from looking at the data in your tables.  Any
user can link to the tables from another db and see what's in them.

Any user can push the shift key when opening the db to bypass the startup
settings, including a startup form that's modal.  Any user can change the
form to design mode and remove the modal setting.

Any user can change the setting to show hidden objects.

Converting to mde doesn't do *anything* to the tables. 

Read and study the security faq if you want to secure Access (Jet) tables, or
link to secure tables in SQL Server or some other secure db.

http://support.microsoft.com/?id=207793

Chris
Microsoft MVP


Boon wrote:

User log in
To prevent copying the objects of the access database
User in Admin Group Can't Modify Objects
Hide backend folder
Exclusive Notice On Opening mdb
Can't Install Add-In
Check if VBA Code is Disabled
HELP!
User Level Security problem in Access 2003
Options greyed out