talytech
07-16-2009, 11:33 AM
I'm trying to access a secured MS Access database from Excel and my code returns the following error on the CreateWorkspace line. "Cannot start your application. The workgroup information file is missing or opened exclusively by another user."
Could someone please assist me with this. My code is below:
Dim wrkJet As Workspace
Dim dbsConBI_BE As Database
Dim rstProvisional As Recordset
Set wrkJet = CreateWorkspace("", "e3utbl", "mypswd", dbUseJet)
Set dbsConBI_BE = wrkJet.OpenDatabase("C:\Documents and Settings\e3utbl\Desktop\Devl Databases\ConBI_BE.mdb")
Set rstProvisional = dbsConBI_BE.OpenRecordset("tblProvisionalOnboardRequests", dbOpenTable)
Could someone please assist me with this. My code is below:
Dim wrkJet As Workspace
Dim dbsConBI_BE As Database
Dim rstProvisional As Recordset
Set wrkJet = CreateWorkspace("", "e3utbl", "mypswd", dbUseJet)
Set dbsConBI_BE = wrkJet.OpenDatabase("C:\Documents and Settings\e3utbl\Desktop\Devl Databases\ConBI_BE.mdb")
Set rstProvisional = dbsConBI_BE.OpenRecordset("tblProvisionalOnboardRequests", dbOpenTable)