Multiple Users Entering Data

[Guest]

I have created a database in which users use a form to enter data. When two
or more users try and enter new records access does not allow the new records
to be saved. I think this has something to do with the primary key not
allowing for multiple of the same ID number which is good. I know there is a
way to change the way the ACCESS allows multiple users to add, edit and save
data. If anyone knows a solution to this problem please let me know.
-Mike

Access 2003

 

[John Vinson]

I have created a database in which users use a form to enter data. When two
or more users try and enter new records access does not allow the new records
to be saved. I think this has something to do with the primary key not
allowing for multiple of the same ID number which is good. I know there is a
way to change the way the ACCESS allows multiple users to add, edit and save
data. If anyone knows a solution to this problem please let me know.
-Mike

Access 2003

What's the datatype of your Primary Key, and how are you assigning it?
What actual error message are you getting? And what version of Access
are you using? Access is indeed multiuser by default - if you have an
Autonumber primary key, or take proper precautions in the design of
your form for a calculated custom-counter key, there should be no
problem.

John W. Vinson[MVP]