Printable View
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
Get a better database.
:D
I agree with mendhak!!
But just out of curiosity, How many users access the database and how big is the db??
4-5 users
20 MB
/C
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
Read this: http://support.microsoft.com/default...b;en-us;122958
It certainly cured my problem. Hope it helps you!
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.