VB/VBA and Encrypted Access2002 Database

mike123abc · November 11th, 2003, 05:17 AM

Hi,

I'm trying to access an encrypted Access2002 database with VB/VBA+ADO.
All users/passwords are stored in the corresponding .mdw file. How do I tell Access from within ADO (e.g. in the ConnectString) to use THAT .mdw file ? If I don't specify .mdw the file, I get an error.

It is similar to starting Access from the command line by using the /WRKGRP option, only it should be done from within VB/ADO.

Mike

pgtips · November 11th, 2003, 07:24 AM

Found this at http://www.able-consulting.com/ADO_Conn.htm

If using a Workgroup (System Database)

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
           "Data Source=c:\somepath\mydb.mdb;" & _
           "Jet OLEDB:System Database=MySystem.mdw", _
           "myUsername", "myPassword"

note the line "Jet OLEDB:System Database=MySystem.mdw", _

hth
Phil

mike123abc · November 11th, 2003, 08:02 AM

Quote:

quote:Originally posted by pgtips
Found this at http://www.able-consulting.com/ADO_Conn.htm

If using a Workgroup (System Database)

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
         "Data Source=c:\somepath\mydb.mdb;" & _
         "Jet OLEDB:System Database=MySystem.mdw", _
         "myUsername", "myPassword"

note the line "Jet OLEDB:System Database=MySystem.mdw", _

hth
Phil

Thanks ! I tried it and it works. This ends 6 days of browsing, asking around and not getting too useful an info.

Great !