Office 2003 SP3
Hey guys. I've been working at this problem for quite some time but I it's been giving me some issues.
Essentially I'm running a few queries that performs an inner join and then updates one of the two tables
UPDATE TableA AS A INNER JOIN TableB AS B ON A.Dog = B.Dog
SET A.OWNER = B.OWNER
There is essentially 3 or 4 of these queries all run one after the other from a macro. Anyways I began receiving 'Not enough
memory on Temporary Drive' errors. After browsing the internet I tried the 'MaxLocksPerFile' and 'MaxBufferSize' Registry
tweaks to no avail.
The two tables are pulled via ODBC to a large Database for backup (1.5GB). Then exported to my local machine where I work the
magic. I've compacted+repaired the database down to 27 megs. And the two tables only contain roughly 15k-30k rows max.
When running these queries separately I noticed they're trying to update 60+ MILLION rows and then I get the memory error.
I've tried everything [Clean temp file, up paging file, copy and paste all components to a seperate DB, Delete all the rows
in the table and paste them back in from source] and nothing has worked.
Any help is definitely appreciated. Thanks for your time guys.