SQL Linked Tables in MS Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I running MS SQL 2000 on Windows 2003 Server, front end I'm using MS Access
2003 Linked Tables. Select Query responding with non matching numbers data,
when Select query is written in MS SQL client tool it response with correct
numerical information.
Is there a problem with MS Access or a update or service pack that I may need.
 
Can you give us a little more info? What is the query as written in SQL
Server, what about in Access?

If the SQL Server version works, save it as a Pass-thru query and run it
that way. It will most likely run faster on the server than in Access
anyway.
 
Back
Top