How can i get multiuple users on one database?

[IT_Charlies]

I have my database on a server and i want 2 or more users to access that database from different stations at the same time.


I am using MS Access 2010, what do i need to do and how do i do it to allow more than one person on my database?

The database contains 2 tables - table 1 has 1,450,00 records - table 2 will be populated with some of the records from table 1.
Table 2 is empty.
3 sub-forms - 1 main form and 1 report (for labels).

Both tables have the same fields, but not all the fields are filled in and each user will be filling in the fields required.

Each record is a case, and no more than one user will be assigned to a case.

I need at least 2 users working on my database at the same time, i would like to have 4 users working on this database if possible.

Thank You in advance for your suggestions and opinions,
Charlie, ITC

[orange]

Here are some ideas
http://www.accessmvp.com/TWickerath/.../multiuser.htm

[IT_Charlies]

All that article is telling me is that the database will be slow when multiple users are using the database.
i want to know how to let multiple users, use 1 database. how do i allow more than one user to access my database simultaneously?

[pbaldy]

Second paragraph was key; split the db.

[orange]

What is your database and MSAccess experience? Have you split the database into FE/BE? With a copy of the FE on each user's local PC. Have you Normalized your tables? Have you done a Compact and Repair?
Is this your first database?
Have you tried google/bing for an answer?
You haven't told us much of your situation and your question has been asked on various forums.

You may find info here
http://www.fmsinc.com/microsoftacces...dDatabase.html


Tom Wickerath has a lot of technical experience and his approach is referenced by many. Perhaps you should go through it carefully.