I am updating an older app that uses Access via ADOX & OLDEDB. There is a need to allow at times multiple users to have the DB open. I have tried setting the connect string to use "Mode=Share Deny None" and "User Id=admin;Password=;" options, but I still get the File In Use error when the connection is opened.
Here is the current connect string. "Provider='Microsoft.Jet.OLEDB.4.0';Data Source=C:\\TFS\\TrainingDB.MDB;User Id=admin;Password=;"
Many thanks for your assistance.
Pat HanksPosted Oct 5, 2022, 9:16 PM
RAJANIKANT ,
Thanks for the reply, but it needs to stay with the Access DB.
Rajanikant HawaldarPosted Oct 5, 2022, 5:18 AM
You could convert or move the data to change the database to something else like MSSQL or MySQL