How to lock my database?

dealwi8me

Registered User.
Local time
Tomorrow, 01:26
Joined
Jan 5, 2005
Messages
187
Is it possible to lock the database in a way that the users can only access data(insert,edit,delete,view) from the forms i builded?

Thank you in advance!
 
if u mean is there a way to prevent users altering form designs then yes there is.
right click on the form when in design view and change shortcut menu (other tab) to no, this will prevent right clicks. then to prevent users using the menus at the top of the screen show the menus you want users to be a ble to use. then go , tools, startup, and unselect 'allow toolbar/menu changes' this will prevent users from changing what menus they see.

there may be an easier way. but i dont know it :D
 
PARSO dealt with the issues of controlling the menu bar, icon bar, pop-up menus from right-click, etc.

There is also the issue of securing your database using Workgroup security.

Since I don't know exactly what you want to do, my best answer here is to say that it is possible with workgroup security to limit a person's ability to create a new form, report, etc. The "real" way to do this is

1. Look up "Startup Form" as a way to bring up a "Switchboard" - these topics are in your help files.

2. Using Workgroup security, prevent folks from entering Design view on what you've built.

3. Search this forum for topics: Workgroup security; hiding the database window; switchboard forms;

After that, if you have specific questions, you can always come back for more.
 
Before you start messing around with security, make a BACKUP!!!! Security is quite tricky and you can easily lock yourself out of your db. Also, be sure to read the Security FAQ
 
Access security is good but it has a task in life which is to stitch the unwary. I have a couple of text files that unfortunately are too large to post here but if you PM me with an email address I would be very happy to send them. Pat as ever is always correct in saying take a backup before doing anything. I always take at least 2 backups because I will think everything is okay and then copy the amended file as the backup only to find myself stitched up.

Len B
 

Users who are viewing this thread

Back
Top Bottom