I have a dll that updates an Access database.

There's a certain users permits set-up for writing to the database

How can I assign a user for it like, UserID = SomeUser in the connection?

Can you please help?



Thank you for your time in advance



There's a part of the code:

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

Dim adoConnection As ADODB.Connection

Dim adoRecordset As ADODB.Recordset

Dim connectString As String

         Dim objLocalContext As ObjectContext

         Dim objServer As ASPTypeLibrary.Server

         Set objLocalContext = GetObjectContext()

         Set objServer = objLocalContext("Server")



connectString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _

                 "Data Source =" & objServer.MapPath("/data/MyDatabase.mdb")

& ";Persist Security Info=False"





Set adoConnection = CreateObject("ADODB.Connection")

Set adoRecordset = CreateObject("ADODB.Recordset")



adoConnection.Open connectString

adoRecordset.Open "SELECT * FROM MyTable", adoConnection, _

                               adOpenDynamic, adLockOptimistic

etc etc....

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





---

http://www.asptoday.com - the leading site for timely,

in-depth information for ASP developers everywhere.

---

You are currently subscribed to asp_components as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_components-$subst('Recip.MemberIDChar')@p2p.wrox.com