Logon to Access DB ?

How do I log on to an Access database with password protection ? I would appreciate it if anyone can help me.

P.s. I do not want any GUI for this application as it is supposed to be an automated process. Ie; no user input is allowed.

[Serge]

You can use ADO to do that, as long as you know the UserID and the Password:

    Dim cn As New ADODB.Connection
    
    cn.Provider = "Microsoft.Jet.OLEDB.3.51"
    cn.Open "D:\Microsoft Visual Studio\VB98\Nwind.mdb", "MyLoginID", "MyPassword"
    
    rs.Open "Select * from customers", cn, adOpenStatic

''''''And so on...

Regards,

------------------

Serge

Software Developer
[email protected]
[email protected]