Creating access database

[Rawb]

If multiple users are going to enter data into the same Table at the same time, you can run into Record Locking issues.



If you do happen to run into that, you may want to have users enter their data into a temporary Table (in the frontend). Then, when they are done, they can transfer everything to the main Table using an INSERT query or VBA.

If you are serving 150 users that will all be using the database at the same time, you might also want to look into using SQL Server (or another server-based RDBMS) to store your data. You can still use Access for the frontend.

[June7]

I have split muliti-user db and never had issue with multiple users accessing the same table same time - the same record yes.

[Mohnishkumbhar]

Thanks June7.. how to create separate copy for each user. If create copy of frontend database will it work. I mean only by creating copy of frontend database.

[June7]

Don't really understand the question.

Create backend with tables. Create frontend that has links to backend tables. Build queries, forms, reports, code in frontend. Put a copy of frontend on each user computer.