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.