Need help with multiple users on a form, please.

  • Thread starter alan morgan via AccessMonster.com
  • Start date
A

alan morgan via AccessMonster.com

Hi all, I am having problems with one of my forms in my database. The
database is on a network. The form consists of an "employeeID", "FirstName",
"LastName", and "Date" field. Then a subform with other info and the "date",
"FirstName", and "EmployeeID" fields are linked to the parent form. My
problem is that more than one user can access the form but when two people
are entering data into the records on the subform (even if they are under
thier own employee ID on the parent form) sometimes the form will jump over
to the other person's employee ID and info. I have tried splitting the
database also but the problem continues. Why does this happen and how can I
fix it?

Thanks,

Alan
 
K

Ken Snell [MVP]

Does each user have his / her own copy of the front end file? That is what
is needed!
 
K

Klatuu

The front end database should not be on a shared drive with multiple users
accessing it. Each user should have the front end database on their desktop
so they are the only one using it.
If your database is not spilt, split it. Put the back end (tables only) on
the shared drive, and put a copy of the front end (forms, reports, queries,
modules, macros) on each user's computer.
 
B

BabyATX13 via AccessMonster.com

Under the Tools menu, Then Options, Advanced tab, have you tried to set the
“default record locking” to edited record? not sure if it will work but worth
a shot.
K Board
 
Top