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.
 

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

query links to SQL server and mdb table 1
Query problem (MS SQL and MS Access tables) 2
Linked MS SQL Server Tables 3
MS Access Query criteria Problem 2
Append query in Access to SQL Server 2
Access 2010 append query to SQL is very slow 0
SQL server backend 2
Different results in SQL and Access 16

Back
Top