Multiuser: Database problem

[capri]

Hi

I've done an application in VB6 that uses an Access db.

My problem is that because that are several users updating the db at the same time.
This has caused the db to crash a few times (at least I think it's the multiuser thing that causes this problem)

Any idea on how to solve this ??

//C

[mendhak]

Get a better database.

[twistedthoughts]

I agree with mendhak!!

But just out of curiosity, How many users access the database and how big is the db??

[capri]

4-5 users

20 MB

/C

[biswajitdas]

hi

when u start the updating the table


take the isolation label of ado


it solve your problem

it not anything to the msacess.it is the process of ado and locking

biswajit das

[Birth]

Read this: http://support.microsoft.com/default...b;en-us;122958

It certainly cured my problem. Hope it helps you!

[default user]

It is NOT the database...

I run 50 concurrent users on DAO on MS Access. You can't tell 1 user from 50.

No lockups, little bloat,
100MB database accumalating 5meg/month.

For starts, If you are, stop logging in/out every operation. Set DB object and leave them logged in until app closes or timed out for inactivity.

We've bombarded a DB with appends/updates from 15 stations until achieved without err; test your techniques before you implement them.