| | |
|
|
|
Start access by asking for sql server login |
|---|
| message from Tina on 6 May 2004 |
I have a need to start access by having users login
with their userid/pwd (this should be authenticated
against sql server database).
How can I do in Access.
At present if I run a form, then it asks for userid
password, I want to do at the time or launch.
Next how can I retrieve it in Access to be used with
my queries?
Thank you in advance,
Tina
|
| jj replied to Tina on 6 May 2004 |
Dim rs as adodb.recordset
set rs=new recordset
rs.activeconnection = "provider=SQLOLEDB; Data
source=dbservername; database=dbname; User ID=sa;
Password=pwd;"
rs.source="select * from table1"
rs.Open
good luck!
jj
|
|
Archived message: Start access by asking for sql server login (MS Access Forms)
