Any clue how to get into a secure Access97 DB?? That is, an Access
database that has user-level security on it. This one has me stumped.
Quote:
> I had the same problem as you. Finally I found the solution
> filename="c:\test.mdb"
> conn.Open "Provider=Microsoft.Jet.OLEDB.3.51; User ID=Admin; Data
Source= "
> & FILENAME & "; Jet OLEDB:Database Password=THESECRETPASSWORD"
> > is there some way to access a password protected access database
using
> > dao, something like:
> > set db= ws.OpenDatabase("c:\test.mdb",true,false, ";pwd=password;")
> > where db is type database, ws is type workspace and my access
database is
> > protected w/ the password "password". thank you.
> > ryan
> > --
Sent via Deja.com http://www.deja.com/
Before you buy.