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
Serge_Dymkov@vertexinc.com
Access8484@aol.com