open command via DAO using a different wrkgrp

  • Thread starter Thread starter Eddy Maas
  • Start date Start date
E

Eddy Maas

Hello,

I'm using the open command to open a connection but each
time it says there is not enough security or somebody
opened this exclusive. The problem is the the secured.mdw
is on another place:

I'm using this command :

cn.Open "Data Source=L:\Pallet registratie\DB\pallet
registratie.mdb"

and the workgroup information file is standing in the
following directory : L:\Pallet
registratie\WorkGroup\secured.mdw

Does anybody know how i can open the database with the
secured workgroup file ?

thanks a lot
 
With DAO, you would open a new DBEngine and set your workgroup to the
appropriate file:

DBEngine.SystemDB = PathToYourFiles

Then, open the appropriate Workspace, database, etc etc ...

Check the MS web site for full info regarding this.
 
Back
Top