cannot open database

[Guest]

i know if i have a form or report open in design view it locks other users
from getting into the database, but if 2 users have a form open and they are
entering data and one of them hits the save button at the top it then locks
any new users from entering the database is that save button only for
design changes my users are using like a word or excel save button
when they enter a record in the form i believe they dont need to ever hit
save is there a way to not show this button to the users?

 

[Allen Browne]

Yes, the toobar button is only for saving changes to the form, and has no
effect on the data in the form.

You can create a new toolbar, containing just the items you want, and then
set it as the toolbar for your form (Toolbar property on the Other tab of
the Properties box.) When copying buttons from the existing Form Toolbar to
your custom one, be sure to use Ctrl+drag so you copy them, i.e. don't just
drag them from the existing toolbar or you will *move* them.

If you have multiple users hitting the same database, consider splitting it.
If that is a new concept, see:
Split your MDB file into data and application
at:
http://allenbrowne.com/ser-01.html