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.