Protect tables

[Boon]

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

 

[Chris O'C via AccessMonster.com]

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