MS Access – Multiuser Updating Data at a Time!

[RAJESHKUMAR R]

Dear Friends,

This is my first Thread in MS Access Forum. I feel happy to be part of this moving forward!

I have a Database which contains four different Tables in it!

Basically 3 different tables are belonging to 3 Different buyer data. I would want all four different buyer (A, B & C ) to access (Edit, Update Etc.,) their respective table simultaneously.

Could you please support me with an Input on how to make this happen?

Thanks & Regards,
Rajeshkumar R

[ranman256]

normally, 1 table holds ALL client data.
for you, it may be better to have 1 database hold 1 client data. That way no other client can see another's data.

Is each client going to use it at their office?
or on your network?

[RAJESHKUMAR R]

Hi ranman256,

Thanks for your response!

Each Client is going to access respective table from my Network drive! I don't want to create multiple database to individual client!

Instead, is there any way I can setup login systems, where Buyer A logins with his Username and Password, he will have access to Buyer A Table like wise each buyer can access their table simultaneously!

Thanks & Regards,
Rajeshkumar R

[aytee111]

The table structure is going to cause you issues down the road, you will always be trying to get the reports right. Have ONE table with all the buyers, then ONE table with all the buyer information, link them on BuyerID. Access is designed for multi-user entry and will keep track of who is updating what at any one time.

Then have a table for Users. This will contain their operating system login ID and BuyerID. When the buyer opens the database, the main form will be bound to the users table and you will filter on their login ID. This data comes from
UserID=Environ("username")

Then all your forms/queries/reports will reference the BuyerID which is now displayed on the main form (Forms!MainForm!BuyerID).