BadgerByte
Well-known member
Hi,
We have recently created some appointment software which uses an mdb file to store data. The mdb file is stored in a shared directory and is accessed by several (max 10) instances of the software. The appointments dataset is refreshed every 20 seconds. We are getting the error "could not lock file" every now and then when attempting to fill the dataset in a multi user environment. As you can imagine this is causing a bit of a nightmare! and needs to be resolved urgently, so I need advice. Is using an mdb just plain silly to start with?, should I switch to MSDE/SQL Server? (I realise this is generally a good thing, but a resolution to the access problem would be preferable). Could this be a connection string issue? The current connection string is as follows:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & TheDBPath & ";Mode=Share Deny None;Persist Security Info = False"
Any help would be greatly appreciated.
Thank you for your time.
We have recently created some appointment software which uses an mdb file to store data. The mdb file is stored in a shared directory and is accessed by several (max 10) instances of the software. The appointments dataset is refreshed every 20 seconds. We are getting the error "could not lock file" every now and then when attempting to fill the dataset in a multi user environment. As you can imagine this is causing a bit of a nightmare! and needs to be resolved urgently, so I need advice. Is using an mdb just plain silly to start with?, should I switch to MSDE/SQL Server? (I realise this is generally a good thing, but a resolution to the access problem would be preferable). Could this be a connection string issue? The current connection string is as follows:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & TheDBPath & ";Mode=Share Deny None;Persist Security Info = False"
Any help would be greatly appreciated.
Thank you for your time.
