Database in a Server Environment

I

ITNow

Can I use Access 2000 to crate a Database that will be accessed from at least
5 computers?
 
P

Pieter Wijnen

No problem.
You should however split the Data (Backend = BE) from the functionality
(FrontEnd=FE) & provide each computer (user) with their own copy of the FE.

Pieter
 
I

ITNow

Thanks Pieter for your help. I did split the Database and it worked, but now
when I tried to run a querry it wont let me because "another user is
accessing the same data". What can I do about it?
 
I

ITNow

Thanks John for your help. The five PCs are in the same fast and stable
network.

I have splited the database and it worked. Now when I tried to run a querry
from one of the PCs it gave me a message that the "request can not be
processed because another user is accessing the same data". How can this be
prevented?

Thanks again.

ITNow
 
J

John W. Vinson

Thanks John for your help. The five PCs are in the same fast and stable
network.

I have splited the database and it worked. Now when I tried to run a querry
from one of the PCs it gave me a message that the "request can not be
processed because another user is accessing the same data". How can this be
prevented?
Click to expand...

What kind of query? Access certainly won't let you run two data-modification
queries at the same time on the same record (or set of records). How are the
users interacting with the data? Forms? Running batch update queries? or what?

John W. Vinson [MVP]
 
Top