Lock table

  • Thread starter Thread starter Boon
  • Start date Start date
B

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
 
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.
 
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
 
Back
Top