Multi User Updation. Help!

[Mohideen]

Hi,



I am creating one application in VB6, where the backend is MS Access 2007.
Now the point is this vb6 application would be installed in 20 - 30 Computers & these would be updating & pulling data from the Access Database.
I do not know how to enable multiuser & i also do not need to compromise on Fastest & reliability of the data.
Any help....

[rpeare]

How many concurrent users do you expect to have using your data that will be MODIFYING or CREATING data at the same time? This is a key question. If you are expecting all 20 - 30 to be active at the same time and entering data Access is not the best tool for the job.

There are a couple of things you can do to mitigate any problems with this many users though if you want to try it.

1. split your database into a FRONT END/BACK END, there is a tool within access that will do this for you.
2. give each user a copy of the front end database and let it reside on their workstation

The way I have done this in the past is to store the front end and back end in the same directory and make multiple copies of the front end and just name them for the person that will be using them so it's easy to tell which person is using which database. The only caveat here is that everyone on the network must have location of the back end mapped to the same directory or you are going to have to go around to each machine and re-establish the link connection

3. DO NOT use any bound forms. Only use unbound forms to add, update, delete, look up any records. This will minimize your exposure to multiple people creating, deleting or updating the same record.

[ssanfu]

You might also explore using SQL Express as the back end. It is a little more robust than Access as a back end.