How to lock the structure of tables?

rpshi

New member
Local time
Today, 05:12
Joined
Jun 23, 2004
Messages
6
I need to send out tables to users to get some information. My boss wants these tables' structure to be unchangable. :confused: How can I do it?
Thank for the help.
 
What do you mean "send out tables"? :confused: surely if people are using a database in the normal way then the table structure will be locked down as part of the Db construction.

Col
 
Sorry I didn't explain it clearly in the earlier post.
Acturally I just picked up this one so I'm not very clear about it.
The condition is, we have a DB here and we are going to send a part of our DB to our customers to collect some information we need. We don't want them to change anything. How can I do it?
I know there is a kind of files called MDE. I tried and failed. :(
 
making an MDE will not protect the table structure, use Access security, and the best of luck
 
A simple method

You bould be better off to create a form to accompany your table so they only have access to the fields which you specify.
In the startup menu under tools deny them access to every view including the database view and use code to dissable shift overide.Start the database with your form.

If somene tries to alter your table structure, they must be desperate.. :) :)

PS remember how to reverse the changes but you should still be able to import the tables from an "Active" database from their reply. :eek:
 
Last edited:

Users who are viewing this thread

Back
Top Bottom