Allow multiple users to enter data to a table?

B

bgarey

I have an access program set up on our network. As many as six people are
entering data at the same time. They are using a form connected to a table.
The problem is that the program will only allow one user at a time to enter
data into the form. If the form is open on more than one computer, it only
allows data from the computer that opened the form first. How can I get
around this?
 
L

lbodell

1st advise doing this on a copy
Under Tools Menu, select Database Utilities, Database Splitter. This
creates a 'frontend' and a 'backend'. These are linked together on the
network (forms and queries in the frontend for users and the underlying
tables are the backend which hold all the data). This has worked well with a
small group 3-4 people.
 
B

bgarey

I have two linked databases. Everything works okay in both programs as long
as one person is using it at a time. The problem is if more than one person
has the same form open at the same time, it only accepts data from one user.
The other users will submit there data, but the table does not accept the
data.
 
Top