I am getting the message "You do not have exclusive access to the database at this time" whenever I try to make changes to my forms.
This problem only happens after I run the following statements and I get the message "Cannot access C:\SALON-NET\Data\Salon-Net_be.mdb; file already in use"
Dim wrkJet As Workspace
Dim db As Database
Set wrkJet = CreateWorkspace("NewWorkSpace", "admin", "", dbUseJet)
Set db = wrkJet.OpenDatabase("C:\SALON-NET\Data\Salon-Net_be.mdb", True, False, "MS Access;PWD=test01")
Although I have 3 PC's on the network, the database is not shared, and the folders are not shared, and no one else is accessing the database.
If I bypass the statements above then I do not have a problem at all, but I need to run those statements as they are at the start of the main form and they do any updates to the backend database that are requried such as adding fields ect. This is just version control so that if I install the application on another PC it does the same updates to the backend database on that PC also if you see what I mean.
I haven't always had this problem.
I have looked for answers on this forum and the internet for weeks now and still cannot get it sorted out.
I tried unistalling Adobe Accrobat which I have seen suggested (Could something still be hanging around) although another PC has the same problem and that has never had Adobe Acrobat installed on it..!
I have also tried following the advise on the Microsoft site. Renaming the files/moving it to another folder ect
Any ideas?
This problem only happens after I run the following statements and I get the message "Cannot access C:\SALON-NET\Data\Salon-Net_be.mdb; file already in use"
Dim wrkJet As Workspace
Dim db As Database
Set wrkJet = CreateWorkspace("NewWorkSpace", "admin", "", dbUseJet)
Set db = wrkJet.OpenDatabase("C:\SALON-NET\Data\Salon-Net_be.mdb", True, False, "MS Access;PWD=test01")
Although I have 3 PC's on the network, the database is not shared, and the folders are not shared, and no one else is accessing the database.
If I bypass the statements above then I do not have a problem at all, but I need to run those statements as they are at the start of the main form and they do any updates to the backend database that are requried such as adding fields ect. This is just version control so that if I install the application on another PC it does the same updates to the backend database on that PC also if you see what I mean.
I haven't always had this problem.
I have looked for answers on this forum and the internet for weeks now and still cannot get it sorted out.
I tried unistalling Adobe Accrobat which I have seen suggested (Could something still be hanging around) although another PC has the same problem and that has never had Adobe Acrobat installed on it..!
I have also tried following the advise on the Microsoft site. Renaming the files/moving it to another folder ect
Any ideas?
Last edited: