SQL 2005 and Access 2003

[SHIPP]

We are having problems with retrieving data from a SQL 2005 database using
Access 2003. Are there documented problems/issues?

 

[Stefan Hoffmann]

hi,

We are having problems with retrieving data from a SQL 2005 database using
Access 2003. Are there documented problems/issues?

Yup, any search engine may guide you to it. Do you have any specific issues?


mfG
--> stefan <--

 

[SHIPP]

I've tried doing searches and I do not turn up anything. Suggestions for
search words????

 

[John Spencer]

You might want to be a bit more specific on what problems you are having
and how you are connected to the SQL 2005 Server?

Are you using an ODBC connection?

Are you using the correct SQL driver (hint: it should have Native in its
name)?

Do you have specific queries that cause problems or is it all queries?

Is it intermittent problem and does it always happen?


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================