John Skolits
Support at CorporateDataDesign.com
Mon Jun 7 10:17:35 CDT 2004
Anyone run into a problem where the PrivDBEngine objects doesn't work on
some XP machines?
I've been using this routine for years. It allows me to make database
changes to secure databases as long as I have the correct system.mdw
security file.
Specs: Written in Access 2000. Resides in an Access 200 MDE library file.
Problem occurs runtime or even if PC is already loaded with Access 2000, or
XP loaded. Very intermittant.
Comes up with an ODBC error/DSN error.
Here is a snippet of code:
It breaks at line 160
Snippet:
Dim dbe As DAO.PrivDBEngine
Dim wsp As DAO.Workspace
Dim dbEXT_Database As DAO.Database
Dim strSecurityFileName As String
30 strSecurityFileName="c:\test\system.mdw"
90 Set dbe = New PrivDBEngine
100 With dbe
110 .SystemDB = strSecurityFileName
120 .DefaultUser = "USER"
130 .DefaultPassword = "PASSWORD"
140 End With
150 Set wsp = dbe.Workspaces(0) 'systemdb is locked in now
'Check the table from the external back end. If There return a true
160 Set dbEXT_Database = wsp.OpenDatabase(strDataBaseFileName)
ALSO, Teery Kreft has done some work in this area. Anyone have her web site
or email address?
John Skolits