473,322 Members | 1,714 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

How to Lock and Hide Access Tables?

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
2 9746
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Roy Padgett | last post by:
I have a combo box where users select the customer name and can either go to the customer's info or open a list of the customer's orders. The RowSource for the combo box was a simple pass-through...
6
by: deko | last post by:
Now that users are handy at importing tables from an Excel spreadsheet, I've discovered a very dangerous problem. If the user decides to name the imported table the same name as an existing...
5
by: jeff.ranney | last post by:
Hi all. I wrote this C# code: lock(this) { / /write to a file }
6
by: Peted | last post by:
Hi wondering what is the best way to do this Need a user to click a button, that sends 3 or 4 string based commands via a TCP/ip socket link I can connect to the ip device no problems, am...
5
by: Jennifer.Berube | last post by:
What is it exactly that makes application.lock such a bad thing? I just need a better explanation or link to a resource desribing it's downfall.
2
by: fredloh | last post by:
it is easy to go to the database window to double click on a table and open it. it is also possible to import or link tables of a secured database and open up the tables in a new database. is...
6
by: michael.spoden | last post by:
Hi, how can I fix lock-waits during an online backup? Is an online backup in DB2 V8.2 not realy online? I'm using DB2 V8.2 Fixpak 15 on Linux. The command to perform the backup is: db2 backup...
6
by: RLN | last post by:
RE: Access 2003 My users have an .MDE as their front end. With this .mde they can still get to the container, double click a table, and modify data on the back end. What is the best way to...
25
by: zmickle | last post by:
Excuse my noobness. I am managing an access database that is shared by 4 users. Management does not want to use any technologies outside of access for this application (no SQL Server, etc). I...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.