Implement user level security on your database, and change your data access
strategy to use RWOP queries instead of tables. Then, you can remove all
access to tables. Distribute your database as an .mde file. Make sure to
remove the ShiftKey Bypass option and set the proper startup options. Google
on RWOP to find out more ... and download the Access Security FAQ and read
it thoroughly before attempting to apply security.
http://support.microsoft.com/default...ent/secfaq.asp
--
Scott McDaniel
CS Computer Software
www.thedatabaseplace.net
"G.Gerard" <gg*****@nbnet.nb.ca> wrote in message
news:G%********************@ursa-nb00s0.nbnet.nb.ca...
Hello
I have a runtime application created with Access 2000 that I want to
distribute.
I would like to lock and/or hide some tables in this application so that
they
could only be modified by the application itself and not be available for
modification by someone opening the application with a version of
Microsoft Access.
I would like these tables to behave like a System object.
Is this possible?
Thanks
G.Gerard