Record Locking (Multi User)

[Neil Mansell]

I have a database that is going to be viewed on 2 pc's so i need it to be
mulit-user.
i don't need users to log into access database but i will need a way to lock
the record that each user is viewing.

is there an easy way to do this within access so it displays a message
saying that record is currently locked or should i just add a reclock
(true/false) field and allow the database to make the field true upon
opening and false when they leave that particular record. this is one way i
thought would be easy to lock the record.

Please reply to newsgroup and my personal email:

(e-mail address removed)

Regards,

Neil

 

[Ken Snell [MVP]]

Split the database into a front end (forms, queries, reports) and a back end
(tables). Give each user a copy of the front end. ACCESS will automatically
lock the records that one user is editing without any work by you.

 

[Ken Snell [MVP]]

I forgot to mention that the backend db should be put in a shared folder
that both PCs can access. The Database Splitting Wizard can help you do this
and will put the backend where you tell it to put the backend.