Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How can I link sqlserver table in access 2000 without ODBC ?
- Thread starter gg70
- Start date
Cornerstone
MIS
Try using ADO to make the connection:<br><br>Dim cnSQLConnect as ADODB.Connection<br>Dim rsMYRecords as ADODB.Recordset<br><br>Set cnSQLConnect = CreateObject("ADODB.Connection"
<br>cnSQLConnect.provider = "SQLOLEDB"<br>cnSQLConnect.ConnectionString= "User ID=sa;Password=; " & _<br> "Data Source=Servername;" & _<br> "Initial Catalog=yourtablename"<br>cnSqlConnect.Open<br><br>Set rsMYRecords=CreateObject("ADODB.Recordset"<br>rsMYRecords.Cursorlocation=adUseClient<br>rsMYRecords.LockType=adLockBatchOptimistic<br>rsMYRecords.CursorType=adOpenStatic<br><br>rsMYRecords.Open "Select * from tablename", cnSQLConnect<br><br><br>I am no expert in this but hopefully this will give you something to go on.
<br>cnSQLConnect.provider = "SQLOLEDB"<br>cnSQLConnect.ConnectionString= "User ID=sa;Password=; " & _<br> "Data Source=Servername;" & _<br> "Initial Catalog=yourtablename"<br>cnSqlConnect.Open<br><br>Set rsMYRecords=CreateObject("ADODB.Recordset"<br>rsMYRecords.Cursorlocation=adUseClient<br>rsMYRecords.LockType=adLockBatchOptimistic<br>rsMYRecords.CursorType=adOpenStatic<br><br>rsMYRecords.Open "Select * from tablename", cnSQLConnect<br><br><br>I am no expert in this but hopefully this will give you something to go on. - Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question