Access corrupted Database in multiuser-mode

[Hertreiter]

Hello,

my VB.NET application uses a Access (Access 2000) Database which is on
a OS/2 Server in the LAN. Unfortunately I have often a corrupted
Database when a couple of users
work at the same time with my application. It's always the same table
(the one with
the most traffic) which is affected.
My log-files said that the users always normaly closed the application
and an the Connection are also normaly closed.

I opend the Database with the following connectionstring:
"Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data
Source=xyz.mdb;Jet OLEDB:Database Locking Mode=0; Mode=Share Deny
None;Jet OLEDB:Engine Type=5"
Any ideas?

Thank you for reading!
Many Thanks for answering!

[tomb]

Use a real database, like MySql or even Foxpro - anything but Access.

T

Hertreiter wrote:

Hello,

my VB.NET application uses a Access (Access 2000) Database which is on
a OS/2 Server in the LAN. Unfortunately I have often a corrupted
Database when a couple of users
work at the same time with my application. It's always the same table
(the one with
the most traffic) which is affected.
My log-files said that the users always normaly closed the application
and an the Connection are also normaly closed.

I opend the Database with the following connectionstring:
"Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data
Source=xyz.mdb;Jet OLEDB:Database Locking Mode=0; Mode=Share Deny
None;Jet OLEDB:Engine Type=5"
Any ideas?

Thank you for reading!
Many Thanks for answering!