Database in a Server Environment

[Guest]

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

 

[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

 

[John W. Vinson]

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

Yes, if the five computers are on the same fast, stable LAN. If one computer
is in Poughkeepsie and the rest in Schenectady, it's harder.

Split the application when you do this:
http://www.granite.ab.ca/access/splitapp.htm

John W. Vinson [MVP]

 

[Guest]

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?

 

[Guest]

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

 

[marco]

hallo.....!!!

 

[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?

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]