Default user id for the linked table

V

Vandy

Hi
I am planning to use default user id and password ( user not having
option to enter the user id and password details) to the query. I am
using the DAO query as follow to connect to the linked table.

StrSQL = "SELECT * FROM qrytest WHERE testid= """ & StrInput & """;"
Set rs = CurrentDb.OpenRecordset(StrSQL)

and one more query is

StrSQL = "Insert into testlib_tabtest (field1,field2) " & _
"VALUES (""2""," & StrInput & ");"
CurrentDb.Execute StrSQL, dbFailOnError

For both scripts, I need to pass the user credentials. Could you please
advice how to do that?

Thanks.
 
Top