Updating Access Tables from SQL

  • Thread starter Thread starter GUIDMonster
  • Start date Start date
G

GUIDMonster

Hi,

I have an access query, which runs from 4 tables linked with SQL server
2005. Firstly, it takes couple of hours to link these 4 tables. and then it
returns wrong results, when compared to same query results on SQL.

I believe, there is a problem with linking table. The repeat entries in
Access results makes me believe that everytime i update tables, it does not
fully empty access tables first, and starts. adding.

Any clues, how to go about this?
 
Can you post the text of your SQL statement, so we can see what it is trying
to do?

It sounds like you are appending records to a table in Access, is that the
case? How many records are returned by the query if you run it as a select
query?

Dale
 

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

Update access table to sql table 1
Update table with values from another table 2
Access 2010 append query to SQL is very slow 0
update query ODBC--call failed 3
UPdate SQL Table Access 2007 6
SQL to export query into table 1
Help With SQL Update 1
Update Table Field Value with SQL Query 2

Back
Top