Previous Thread

8/18/2006 9:41:02 AM    Appending Records
I have 2 databases with the same tables.  I need to merge the data from 
 
database 2 into database 1.  I created an append query but I keep getting a 
 
"not enough space on temporary disk" error.  I even limited it down to 3 
 
months worth of data and i still get this error.  if i limit it down anymore 
 
it would take me way too long to append all the data from every table.  Help!



8/18/2006 10:51:32 AM    Re: Appending Records
Heidi 
 
How large are your two .mdb files? 
 
Regards 
 
Jeff Boyce 
 
Microsoft Office/Access MVP 
 
"Heidi" <Heidi@discussions.microsoft.com> wrote in message 
 
news:628F450B-F6E7-4F95-9D3A-022BD008B1B5@microsoft.com...