database in a network enviroment

[Cameron]

I am running a database across a network and need to know how to have it open
in "read only" or "Locked" mode, similar to what Excel does when more than
one person opens it. I have several people that will be editing a form and
need to keep them from doing it at the same time. Anyt suggestions would be
great.

Thanks
Cameron

 

[Rick B]

Check out Tools/Options/Advanced/default record locking

Rick B

 

[Tim Ferguson]

I am running a database across a network and need to know how to have
it open in "read only" or "Locked" mode, similar to what Excel does
when more than one person opens it. I have several people that will be
editing a form and need to keep them from doing it at the same time.

Depends a little bit what you mean by "editing a form". If you mean
actually moving the controls round and changing the properties and so on,
then you can't; Access becomes extremely unstable; and you really don't
want to do that anyway. Either have one developer or give everyone a
separate mdb to screw up on their own.

On the other hand, if you mean people using the same form to edit records,
then this is standard Access fare. The safe strategy is to split the
database, so that the tables and relationships stay in one shared "back
end" mdb, while the forms, reports and code are collected in a "front end"
mdb which is installed locally on each user's PC. For detailed information,
google for "splitting database" or continue to watch this group.

Handling clashes on individual records is handled internally by Access
itself, for the most part fairly successfully.

Hope that helps


Tim F