John,

Thanks, does that also work if one table is on Sql Server and the others are
in Oracle but are also linked in.



John W. Vinson wrote:
I have compacted the DB several times the ACCESS portion is 3,256 KB in size,
but when the SQL rus and uses the linked SQL server table, it is building a
temp file that is over 2 gig. Is there anyway to not use the temp file, or
committ the records every so often to the file so the temp file doesn't get
to large?

If you're appending data from one linked SQL table into another linked SQL
table, consider using a "Passthrough" query so it's all handled on the server.
This will not generate a (local) temp table and will not be subject to Access
size limits.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200911/1