View Single Post
  #8 (permalink)  
Old November 14th, 2003, 09:02 AM
SerranoG SerranoG is offline
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG

The Man from UNCLE's advice is good... put the tables and queries in an MDB file and put the forms and reports in an MDE and link them.

You can password protect the MDB half with the tables so that users cannot edit them. They will only able to affect the data via the forms in the MDE. The MDE half will be only available in a limted way so they cannot do damage.

Remember to keep an MDB version of the forms and reports so you can upgrade them at a later time. When you upgrade them, turn them into an MDE again and give that to the users again.

Just remember, keep-back ups of everything unprotected with no passwords, etc. somewhere where only you can get at it so if you accidentally get locked out you have the source information.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply With Quote