Two Workgroup Files at once


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Two Workgroup Files at once

  1. #1
    Chris Jantze Guest

    Two Workgroup Files at once


    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.

  2. #2
    Ted McNeal Guest

    Re: Two Workgroup Files at once


    "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





Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center