[dba-VB] Open DB

The PrivDBEngine is an unsupported object. But, I use it all the time to
modify backends that I have locked out. Never had a problem.

If you subscribe to 'Smart Access' there is an article on PrivDBEngine. I
don't subscribe to Smart Access but I'm sure someone on the list does.
Maybe someone can get a copy for you. I'm sure it will list all the
properties and methods of the object.


Here's a page that has the link for PrivDBEngine:

http://www.myjavasource.com/sa/samain.nsf/0/B0D0397E0CFFBEA88725689D00799FB7

John Skolits




-----Original Message-----
From: dba-vb-admin at databaseadvisors.com
[mailto:dba-vb-admin at databaseadvisors.com]On Behalf Of Griffiths,
Richard
Sent: Thursday, February 27, 2003 10:27 AM
To: 'dba-vb at databaseadvisors.com'
Subject: RE: [dba-VB] Open DB


John

Well done - this is perfect

BTW what is PrivDBEngine  - can't find in object browser

Are there any implications using this method?

Thanks
Richard

> -----Original Message-----
> From:	John Skolits [SMTP:JSkolits at CorporateDataDesign.com]
> Sent:	27 February 2003 13:20
> To:	dba-vb at databaseadvisors.com
> Subject:	RE: [dba-VB] Open DB
>
>
> See if this works for you
>
> '****************
>
> Dim dbe As DAO.PrivDBEngine
> Dim wsp As DAO.Workspace
> Dim dbEXT_Database As DAO.Database
> Dim strSecurityFileName as String
> Dim strFullDatabasePath as String
>
> strSecurityFileName="c:\Windows\Ssytem\system.mdw"
> strFullDatabasePath = "c:\Test.mdb"
>
> Set dbe = New PrivDBEngine
> With dbe
>      .SystemDB = strSecurityFileName
>      .DefaultUser = "User"
>      .DefaultPassword = "Password"
>  End With
>
>  Set wsp = dbe.Workspaces(0)  'systemdb is locked in now
>
> Set dbEXT_Database = wsp.OpenDatabase(strFullDatabasePath)
>
>
> '**************
>
> I didn't check all the syntax but it should be OK
>
>
> John Skolits
>
>
> -----Original Message-----
> From: dba-vb-admin at databaseadvisors.com
> [mailto:dba-vb-admin at databaseadvisors.com]On Behalf Of Griffiths,
> Richard
> Sent: Thursday, February 27, 2003 8:08 AM
> To: 'AccessD at databaseadvisors.com'; 'dba-VB at databaseadvisors.com'
> Subject: [dba-VB] Open DB
>
>
> Hi Group
>
> Can't seem to find the exact bit of code I need......to be able to open
> another database which has its own password and is in a different
> workgroup
> using DAO.
>
> Can find code for this....... to open another database which has its own
> password  using DAO
>
> Anyone been there?
> Thanks
> Richard
>
> --------------------------------------------------------------------------
> --
> ----------------------------------------
> This e-mail, together with any files transmitted with it, is
> confidential and intended solely for the use of the individual to
> whom it is addressed. If you are not the intended recipient, or
> the person responsible for delivering to the intended recipient,
> be advised that you have received this e-mail in error and that any
> use, dissemination, forwarding, printing or copying of this e-mail
> is strictly prohibited without liability on our part.
>
> If you have received this e-mail in error please notify the sender.
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>
>
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>
----------------------------------------------------------------------------
----------------------------------------
This e-mail, together with any files transmitted with it, is
confidential and intended solely for the use of the individual to
whom it is addressed. If you are not the intended recipient, or
the person responsible for delivering to the intended recipient,
be advised that you have received this e-mail in error and that any
use, dissemination, forwarding, printing or copying of this e-mail
is strictly prohibited without liability on our part.

If you have received this e-mail in error please notify the sender.
_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com