View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ctmom@comcast.net is offline
external usenet poster
 
Posts: 5
Default Excel not visible and get Not enough system resources to display completely

Thank you for the Application.DisplayAlerts=False idea. It works like
a charm, but as I understand it, it will no longer show any errors.

The same process described above has been getting another error 3034
Disk or network error intermittently. It sometimes halts the process.
For example, it will error on Mon (around 5:26am) but not on Tues.
When it errors, it gets thru compacting 3 of the 6 databases then gets
the error. On days it works, it compacts all 6 successfully.

An additional error that I think is related is error 52 Bad file name
or number when I run "Copyfile DBEngine(0)(0).Name, Left
(DBEngine(0)(0).Name, Len (DBEngine(0)(0).Name) - 4) & BACKUP.mdb".
This executes when my db, that does the compacts the other 6, closes.
This is also intermittant. Our tape backup does not backup open files,
and this one and another db stay open 24x7. Gotten the error on both.
I do reboot the machine every weekday. I have checked TEMP and TMP. I
have compacted both dbs manually.

Our network person is working with Microsoft. They will be doing
traces but since it errors on the same db I keep thinking it's a db
thing.
Any ideas?
Thanks!
Kristy