Access -- >SQL Provider Syntax

[jurgen]

Hi,

Does someone can help me, what's the syntax for a connection in Access Project File to the database with a known username and password that is the same for every user.

rst.open .......


thankx a lot

JJ

 

[DougP]

SQL Server 7 or 2000 ???

' ---------- DSN less ------------------
Dim Conn As ADODB.Connection
Dim Rs1 As ADODB.Recordset

Set Conn = New ADODB.Connection
Set Rs1 = New ADODB.Recordset

Conn.Open "driver=SQL Server;server=yourSQLdatabase;uid=sa;pwd=;database=yourdatabase;"
Dim SQLCode As String
SQLCode = "Select ....."

Rs1.Open SQLCode, Conn, adOpenStatic, adLockOptimistic

'Do some stuff with the recordset

Set Rs1 = Nothing
Set Conn = Nothing
'''
I use this everywhere.
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[jurgen]

Thnx

JJ

 

[Georgews]

This is just what I have been looking for also. Thanks guys