PDA

View Full Version : Create Workspace issues



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)

talytech
11-25-2009, 12:28 PM
Does anyone have any suggesstions for the issues with creating a workspace?