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.
Printable View
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.
You can use ADO to do that, as long as you know the UserID and the Password:
Code: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]