Sharing Issues of Access 2002 on a Server?

[Guest]

I will have an access 2002 application on a shared server. Can I have
multiple users using the same problem concurrently and updating the same
tables???

Will Access 2002 handle the issue of sharing with multiple users???

If so, how (general concepts).


It it can't be shared on a server, does anyone have possible suggestions???


Thanks You,

Gary

 

[Larry Linson]

I will have an access 2002 application on a
shared server. Can I have multiple users using
the same problem concurrently and updating
the same tables???

Yes, you can, but see below.

Will Access 2002 handle the issue of sharing with multiple users???

Yes, usually.

If so, how (general concepts).

Access is, out of the box, multiuser capable.

You may run for a long time without problems, but having multiple users
logged in to the same front-end or monolithic database significantly
increases the chances of corruption. Thus, the standard suggested solution
is to split the tables (back-end: tables and relationships) and store them
on the server, but put a separate copy of the user interface (front-end:
queries, forms, reports, macros, modules) on each user's machine.

Distributing and updating the front-end is simplified by MVP Tony Toews'
Front End Updater... http://www.granite.ab.ca/accsmstr.htm. However, I have
had good luck with the simpler approach that you'll find at
http://accdevel.tripod.com.

Larry Linson
Microsoft Access MVP