Word 2000: Open a Secured Microsoft Access Database

[VBA Coder]

I am trying to open a secured Microsoft Access database (.mdw) using VBA
within Word 2000 and Word 97. I have tried to following line of code, but I
get the error "Run-time error '3028': Cannot start your application. The
workgroup information file is missing or opened exclusively by another
user."

I have verified that the MDW file does exist in the folder and that it is
not open by any user, since I am testing on local box.

Dim db As Database
Dim wrkJet As Workspace
Set wrkJet = CreateWorkspace("C:\Test.mdw", "JoeUser", "", dbUseJet)

 

[Perry]

Hi VBA Coder,

If y're calling the Test.MDW workgroup information like in yr below
example, MS Access itself is linked to another MDW file, right?

I presume Access is occupied by the standard
system.MDW workgroup information file, when y're doing the call.

If this is the case, you can't open a workspace through Automation
trying to make use of another MDW file.
You'll have to use a lowlevel (for instance: Shell) command to open Access/
database, using the switch "/wrkgrp" to change the workgroup information
file.
Once this is done, you can use GetObject() to obtain the Access instance.

I wud turn to the Access newsgroups in order to find out how to use
the SysCmd or Shell command to open a secured database.

Krgrds,
Perry