link sql server table to access

[BrOkEn_iCe]

hi all

i want to know other way to linked sql server to access than use odbc connection

and plz if it's the only way

how i can improve it's performance caz it's too slow

i here i can use oledb but i don't know how i can do that

so plz help me i need it

 

[boblarson]

You say that an ODBC Connection is slow. Where is the SQL Server located in relation to you? Is it in the same building, or another one close by, across the street, etc.?

When is it slow? When you open the table, use it in a query, in a form, what?

We use ODBC Connections here at the place I work they work just fine with lots of data and all. So, we also have to look at your hardware. And, you should ensure that your Network Interface Cards are working properly (both on the SQL Server and the client machines) as that has been the cause of some consternation for several people who have posted similar issues here on the forum before.