talytech
03-21-2011, 09:14 AM
I'm trying to open and connect to an Access database and add data to a table via OpenRecordset. When I try to run the code to test its connection, I get a run-time error '3028': "Cannot start application. The workgroup file is either missing or opened exclusively by another user".
Here is what I have that produces the run-time error. Can you tell me what I'm doing wrong here.
Dim db As DAO.Database
Dim rst As Recordset
Dim wrkJet As Workspace
DBEngine.SystemDB = "R:\GuardServices\TechTeam\auditSecurity.mdw"
Set wrkJet = DBEngine.CreateWorkspace("", "e3utbl", "test")
Here is what I have that produces the run-time error. Can you tell me what I'm doing wrong here.
Dim db As DAO.Database
Dim rst As Recordset
Dim wrkJet As Workspace
DBEngine.SystemDB = "R:\GuardServices\TechTeam\auditSecurity.mdw"
Set wrkJet = DBEngine.CreateWorkspace("", "e3utbl", "test")