Link to SQL Server without ODBC ?

A

AlternaTribe

How do I do to link a table of SQL SERVER directly to MSAccess 2000 without
ODBC?

_________________________________________
AlternaTribe
ICQ#: 15583714
_________________________________________
 
G

GVaught

Use the SQL Server Driver instead that comes with Access. You may also be
able to create a Pass-through query, however I have never done this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC SQL Error Bulk Insert - Null values 1
Connecting to MS SQL Server 1
TransferSpreadsheet method question 2
ODBC to OLEDB - VFoxPro 5
ODBC--call failed. 3
Are there any public SQL-Server databases available for testing Ac 5
docmd.transferdatabase access 2003 to sql 2005 2
Trusted Connection in Pass-trough query... 4

Top