Adding new user id and passwords to Access db's from Delphi

Andrew Lee

Delphi Developer

Tue, 29 Jun 2004 06:32:23 GMT

Adding new user id and passwords to Access db's from Delphi

Hi, can anyone point me in the right direction? I'm trying to add new user
ID's and/or change passwords in an Access 97 database from Delphi (BDE
connection).

thanks in advance,
Andy.

M.H. Avegaar

Delphi Developer

Wed, 30 Jun 2004 03:43:57 GMT

Re:Adding new user id and passwords to Access db's from Delphi

The BDE MSACCESS driver for MS Access 97 uses DAO 3.5. Import the DAO type
library and use it to create users (see www.microsoft.com/data for details
on DAO).

ps. Microsoft no longer updates DAO and advises users to switch to ADO. If
you want to use ADO you need to look at the ADO extensions for DDL and
security (ADOX).

Quote

"Andrew Lee" <andrew-...@supanet.com> wrote in message

news:a1l4q2$ceo$1@chilli.nntp.netline.net.uk...

Quote

> Hi, can anyone point me in the right direction? I'm trying to add new user
> ID's and/or change passwords in an Access 97 database from Delphi (BDE
> connection).

> thanks in advance,
> Andy.

Other Threads

1. Restricting access to db based on user id

2. Converting Access 2000 DB's to Delphi 4 (New convert)

3. Adding new DB user?

4. Adding users and password to Access database at runtime

5. Add New User Won't Work

6. MS Access Encrypted DB's (Password)

7. Adding a New User to an Access Database

8. Interbase Password and User add/change via Delphi?

9. CompactDatabase & use System database,Password,User ID

10. Adding users to an Interbase DB from a Delphi application