Linked Table Question

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I linked a table in Access 2003 from a SQL Server 2005 table using an ODBC
connection and for some reason one of the columns has different data in it
than the source table in access.

I was wondering if anyone has ever came across this issue and have a fix for
it?

Thanks for your help.

-Chris
 
I have had that happen. In my experience, it is timing out before all the
data gets there. Reset the timeout time (in Access) and that may fix it.
 
do your processing on the server, instead of always scanning
everything to the local machine

in other words.. do everything in SQL passthroughs.. (and write an ass-
ton of code to maintain it)
Or move to Access Data Projects

-aaron
 
Back
Top