Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
Problem with ADO Microsoft Jet
I wrote this program with ADO connection string to a microsoft access database (.mdb) file. The program is working great when used as a single computer, but I need it to be a shared multiuser database system. I have the DB shared on the network, and mapp the directory as a drive on the client station. When the program runs, it opens the database by the mapped drive directory. Now when I open the program and database to view data on one client, when I open the other client I get an error saying
Cannot open file "; File already in use.
I am including the code at the bottome because I don't know if its a setting I need to fix in my ado connection or recordset connection setting.
Public Function Open_CentexDB()
If CentexDB.State = adStateOpen Then
DBDriveLetter = CentexDriveLetter.Fields("Drive").Value
CentexDB.Open "Provider=Microsoft.Jet.OLEDB.4.0;persist security info =false;data source=" & DBDriveLetter & ":databasesCentex.mdb"
Public Function Open_CentexTable()
If CentexTable.State = adStateOpen Then
.ActiveConnection = CentexDB
.CursorLocation = adUseClient
.CursorType = adOpenStatic
.LockType = adLockOptimistic
.Source = "SELECT * FROM CentexInfo"
Those are both functions I open up on form load to view the data. Someone please help me, the company I am building this program for does not wish to buy microsoft SQL server to handle database solutions, they wish to use microsoft access.