Board index » delphi » Password issue in ADO & MS Access2000 Database

Graham Plai

Delphi Developer
Sun, 24 Aug 2003 06:56:55 GMT

Password issue in ADO & MS Access2000 Database

Brian,

Quote
> Your advise is not correct.  First Database password is not the same as
> Password.  Usename and Password correspond to the user level security you
put on
> an Access database,  database password corresponds to the option
> |Tools|Database|Set database password'

Yes, I know this. When I read the original posing from Faisal, I reached the
conclusion that he is trying to connect to an Access database with a
database password and not one which has user level security. I based my
deduction on the following quote -

Quote
>>Normally my Delphi5 with Ms access2000 database(ela.mdb) connects
perfectly
>>by ADOconnection. BUT, if I set "Password" from Access (by opening it as
an
>>exclusive method!), my ADO denies to connect it!!

I'm not an expert in Access security, but isn't it the database password
that requires the database to be opened in exclusive mode, while user level
security is set with the workgroup admin utility?

Quote
> Second you can include the password in your connection string if you check
the
> "Allow saving Password" in the connection dialog box.

I tried this and it didn't work for me. I'm using Win98, D5 Pro SP 1, ADO
Express SP1 and DMAC 2.5. However I was in a hurry at the time and I may
have missed something :-) I'll give it another try when I have more time.

Thanks for your comments,
Graham Plain
Prism Comms.

 
Brian Bushay Team

Delphi Developer
Mon, 25 Aug 2003 13:47:47 GMT

Re:Password issue in ADO & MS Access2000 Database


Quote
>Just tell me some thing...(this might be stupid) when i set Password & User
>name in ADO "All" page, does it saves in the connection? or inside the
>Database (*.mdb) itself?

Nothing is saved in the database.  The password is saved as part of the
connection string only if you have the "Allow saving password" checkbox checked
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com
Brian Bushay Team

Delphi Developer
Mon, 25 Aug 2003 13:47:48 GMT

Re:Password issue in ADO & MS Access2000 Database


Quote
>Ok...tell me when yo set password in MSAccess... how do you set an username
>for that?
>because in access... Tools|Security|Set Database password... gives you a
>chance to set only Password.

User names are for user level security
Tools|Security|Set Database is for setting the database password.  
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com
Go to page: [1] [2]

Other Threads