Help with Access 2000 on network

[Todd]

I have an Access 2000 database that resides on a WinXP computer(\\Main). The database uses the autonumber primary key as part of the invoice number. There are two other computers that are networked to \\Main. What is the best way to set up Access so two or more users can use the database simultaneously? All three computers have Access 2000 installed. Thanks for any help.

Todd

 

[Larry Linson]

For an overview of Access in a multiuser environment, download my
presentation from http://appdevissues.tripod.com.
That will get you started with a list of topics that I though worthwhile to
discuss with my user group.

For the most complete collection of information and links on multiuser
Access that I know about, visit MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm.

Larry Linson
Microsoft Access MVP

I have an Access 2000 database that resides on a WinXP computer(\\Main).

The database uses the autonumber primary key as part of the invoice number.
There are two other computers that are networked to \\Main. What is the
best way to set up Access so two or more users can use the database
simultaneously? All three computers have Access 2000 installed. Thanks for
any help.