By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,659 Members | 940 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,659 IT Pros & Developers. It's quick & easy.

How to Lock and Hide Access Tables?

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
On Tue, 16 Dec 2003 01:14:14 GMT, "G.Gerard" <gg*****@nbnet.nb.ca>
wrote:

Yes, by applying Access-level secutiry.
But it's an advanced topic. Before proceeding, download, study, and
fully understand the Access Security FAQ from microsoft.com.
Especially the section on RWOP queries.

-Tom.

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


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.