Data Base Password (ADO)

by **Naser** » March 29th, 2005, 9:19 pm

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

by **Stefan** » March 29th, 2005, 10:16 pm

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

by **Naser** » April 10th, 2005, 6:41 am

tanx

What Is Udl

by **Stefan** » April 11th, 2005, 9:58 am

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

by **Naser** » April 12th, 2005, 6:27 am

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

by **Stefan** » April 12th, 2005, 7:17 am

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

by **Naser** » April 16th, 2005, 2:46 pm

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

Tanx

by **Naser** » April 16th, 2005, 2:48 pm

NaserMokkary@Yahoo.Com

by **Stefan** » April 19th, 2005, 7:15 am

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

Stefan

Data Base Password (ADO)

Data Base Password (ADO)

Who is online