April 2, 2006 at 11:22 am
I have an Access DB for front end with linked ODBC tables. I have to protect these tables from importing into another Access file. I have tried following -
1)hiding tables - Not proper if user sets option for viewing hidden objects
2)Giving Password to Access Project from VBA code screen-Not protecting tables by this method
Is there any solution for protecting to import tables form an Access MDB?
Thanks
April 3, 2006 at 9:09 am
This is the only way I can think of to protect your tables from unauthorized viewing by knowledgable users:
1. Assign a ownership of the "production" database to a newly created user, assign this new user a password, then exit the database.
2. Create a new database whose only purpose in life is to open your "production" database. As this database opens your production database, it will use the newly created user name and password to open the "production" database.
3. Make this "opening" database an .mde database by compiling it.
This works because the users will not know the password you have used in your "opening" database, therefore when they try to get into the "production" database to get at the files, they will not know the password, and therefore be blocked.
Hope this helps
[font="Comic Sans MS"]Vic[/font]
www.vicrauch.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply