Record Locking (Multi User)

  • Thread starter Thread starter Neil Mansell
  • Start date Start date
N

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
 
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.
 
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.
 
Back
Top