Multiple User Access Problem!!

[BlankReg]

Hi there, wondering if anyone can help.

im trying to create a multiple user access database, but i am experincing problems when more then one person is trying to access the same entry fields and this is causing conflicts, the database is stored on a server and is not localised to the network machines. what i would like, is when a form is opened by user 1 (record no 10), user 2 should be able to use the same database form and go to a new record (record no 11) that isnt already in use by user 1.

any advice on enabling the database for multiple user access is welcome.

 

[davea300]

Have you split your database into front end - back end? It's the first thing you should do if you have multiple users over a network.

The front end file will be stored on each users local PC and the tables, the back end, stored on your network server. Each user will have their own front end database linked to the tables stored in the back end file.

Read the access help for more info on database splitting.

 

[BlankReg]

Hi there, thank you for your reply.

what would be your recommendation on how to approach this? i've tried splitting the database before but had no luck. please could you provide more information on how you would go about doing this procudure.

 

[GohDiamond]

I just addressed this issue under the topic: "Split and Replicate " in today's posts.
Check it out. It may help.

Regards,
Goh