There isn't enough disk space or memory to undo the data changes *

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with 1.4 million records on it. Every morning we have to
delete the table, import data from a unix based program. Re-create the table.
Then use a macro to add information to the table that the unix info doesn't
have. Every time this is query is ran, the message pops up. Normally not a
problem but we are trying to run a batch program that will do this all before
eveyone comes in to work because its a rather lengthy process.

Is there a way to eliminate the message from popping up? or is there a way
to correct the issue completely?
 
After deleting the table do a compact and repair before re-creating the table.

Also when re-creating the table, don't put any indexes in it until after the
records are added. You may need the primary key index.

Another possibility is to only add data to part of the records at a time
with the macro. Something like update the names that start with A through D
with one query then E through H, etc.
 
Hi.
or is there a way
to correct the issue completely?
Click to expand...

Try increasing the MaxLocksPerFile database option, and if that doesn't
work, avoid doing the operation within a transaction, which is the default.
For instructions on how to do these, please see the following Web page:

http://support.microsoft.com/kb/286153

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Back
Top