Two Workgroup Files at once

[Chris Jantze]

I am developing a conversion program to port our users' data from Access 2.0
to Access 2000. The workgroup file for the new databases has changed since
the username and password were leaked on the older one. It seems the file
is set when DBEngine.SystemDB is set at startup. I need to able to open
both the old and new databases with two workgroup files at once.

1) Is this possible?
2) Is there a work around for it?

Thanks in advance.

[Ted McNeal]

"Chris Jantze" <tech@addison.attbbs.com> wrote:
>
>I am developing a conversion program to port our users' data from Access
2.0
>to Access 2000. The workgroup file for the new databases has changed since
>the username and password were leaked on the older one. It seems the file
>is set when DBEngine.SystemDB is set at startup. I need to able to open
>both the old and new databases with two workgroup files at once.
>
>1) Is this possible?
>2) Is there a work around for it?
>
>Thanks in advance.

Chris,

There is a hidden top level database engine object that you can use to connect
to databases in another workgroup. It is called privDBEngine. Is operates
the same as the default database engine DBEngine.

Dim dbe as DAO.privDBEngine
Set dbe = New DAO.privDBEngine
dbe.SystemDB = "The path to the other workgroup file"


Ted McNeal