Pat Hanks

Pat Hanks

  • 1.7k
  • 81
  • 1.2k

Is it possible to se the Access Default Open Mode from C# code?

Sep 30 2022 1:21 PM

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. 


Answers (2)