DELPHI AREA Forum

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

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

tanx

What Is Udl

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

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

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

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

Tanx

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

Stefan