Re: DAO 3.51
- From: "Steve Gerrard" <mynamehere@xxxxxxxxxxx>
- Date: Thu, 14 Jun 2007 07:50:33 -0700
"Rick" <Rick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0404FCE4-E269-469B-BA03-857915841C93@xxxxxxxxxxxxxxxx
Sure.
DB Creation(DAO):
Set dbLocal = DBEngine.CreateDatabase("C:\WorkDir\MyDB.mdb", dbLangSpanish &
";pwd=Mypwd", dbEncrypt)
--- later ---
DB Connectio(ADO):
MyCnn.Open "Provider=Microsoft.Jet.OLEDB.3.51; Data
Source=C:\WorkDir\MyDB.mdb;User ID =Admin;password=Mypwd"
And the error is that there is a problem with password or User ID.
--
You have not created a database with a password for the default Admin account.
You have created a database with a database password, something which is
independent of the user account.
For your ADO connection, you need to specify the database password, not a user
id and password, something like this:
MyCnn.Open "Provider=Microsoft.Jet.OLEDB.3.51; Data
Source=C:\WorkDir\MyDB.mdb;Jet OLE DB:Database Password=Mypwd"
Note that user accounts are managed in a separate workgroup database (i.e.
system.mdw), and then individual databases can grant various permissions to
various users in that workgroup. There is no sense in which a particular
database has a password for the Admin account.
.
- References:
- Re: DAO 3.51
- From: Dave O.
- Re: DAO 3.51
- Prev by Date: Re: Compile Only
- Next by Date: Re: FindFirstFile Possible Memory Leak
- Previous by thread: Re: DAO 3.51
- Next by thread: Re: DAO 3.51
- Index(es):
Relevant Pages
|
