Data Base Password (ADO)

Naser · Posted: 29/03/05 21:19 Post subject: Data Base Password (ADO)

I want set database password in Access and open database in delphi without password.

Stefan · Posted: 29/03/05 22:16 Post subject:

I'm not entirely sure if I know what you mean but you can try this:

Create a file called "access.udl"

Edit that file (by double clicking on it)
- Select the Microsoft Jet 4.0 driver
- Go the next tabsheet and select the MDB file you wish to connect to
- Fill in the username "admin" and the password associated with that account
- Test the connection by clicking "Test Connection"
- Save the file

Back in your in Delphi project:

- Set the LoginPrompt property to false (assuming you are using a TAdoConnection).
- Set the ConnectionString property to "FILE NAME=Access.udl"
- Then try connecting by setting the Connected property to true.

Cheers,
Stefan

Naser · Posted: 10/04/05 06:41 Post subject:

tanx

What Is Udl

Stefan · Posted: 11/04/05 09:58 Post subject:

Hi,

UDL stands for Universal DataLink.
It's file-extenstion (.UDL) is linked to a little editor that allows you to easily configure connections to datasources.

Cheers,
Stefan

Naser · Posted: 12/04/05 06:27 Post subject:

when enter password And user name : admin , an error happen : invalid password
sory , i english not very good .
bye

Stefan · Posted: 12/04/05 07:17 Post subject:

Hi,

Are you sure you have selected the "Microsoft Jet 4.0 OLE DB Provider"?
Are you sure about the password? (is there a password? default the password is empty in MS Access).

Stefan

Naser · Posted: 16/04/05 14:46 Post subject:

Yes
can you build a delphi program with database password and send source for me ?

Tanx

Naser · Posted: 16/04/05 14:48 Post subject:

NaserMokkary@Yahoo.Com

Stefan · Posted: 19/04/05 07:15 Post subject:

I've sent a demo to your yahoo address... Let me hear how it went!

Stefan