ADO / Excel & Access: User ID and Password
 

Does anyone know how to build up users and passwords in Acces and then access
the Database from VBA code in Excel?

in Access:
ToolsSecurityUser and Groups Accounts

There I can set up "Admin" and "User" accounts and set up password for both.

Then when I build up a connection using ADO in VBA/Excel I would use a
string like the following:

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & ActiveWorkbook.path & "\DBase.mdb;" '& _
"User ID=Admin;" & _
"Password=pass;"


would this be correct?

Thanks & Bregards

Santiago