Lock table

[Boon]

Hi,

I am creating an application for other people to use. I have one form and 5
tables in my application. The form is just looking into 5 tables and display
the results. The form does not change anything in the tables at all.

I would like to lock all the tables so that the users cannot change anything
in the tables. How can I do this?

The application is a standalone and I plan to distribute it as a .mde.

Thanks in advance your your helps.

Boon

 

[Golfinray]

Once you split your database, locking the tables won't be an issue because
users won't be able to change them anyway. You (I assume) have a LAN and
would put the backend on the lan and a copy of the frontend on each users
computers. Check Joan Wild's website for details at www.jmwild.com or google
Albert Kallal. He has a good explaination at his website also.

 

[Boon]

Hi,

Thanks for your advise. However, I want my application to be a standalone
application. Spliting database is not an option. Is there a way to do this
in a single database?

Thanks,
Boon

 

[Chris O'C via AccessMonster.com]

Implement user level security, remove all users' permissions to the tables.
Give the default admin user permission to open/run the db and the form.

When you create the form, use a sql query in the form's record source that
allows "run with owner permissions" (RWOP). Do the same for any other
queries needed in combo boxes, etc. so no queries are listed in the database
window. Then distribute the db *without* the secure workgroup file. The
users will be able to open the db and the form while joined to the default
workgroup, but won't be able to open the tables to edit them.

Chris
Microsoft MVP