recommend you split your database, all tables to a Backend file, and all
other objects to a Frontend file, and back up both - the backend db each day
(or each time you edit data), and the frontend db each time you make design
changes. until you can identify the problem and prevent it from recurring,
at least you shouldn't have to keep building the db from scratch.

hth


"redD" wrote in message
...
I have been working with a database (that I have created three times from
scratch) with many macros and vba modules. Every once in a while when
opening the file it looks like all of the vba code gets deleted and when I
fix it up the program always opens with the same following message:

"The system you are saving to does not have enough memory to remove
personal
information from file properties. All personal information may not be
removed"

I have not been able to find any information regarding this message and I
have to keep rebuilding the database, after the second time I had exported
all of my vba code but this is getting ridiculous. Does anyone have any
ideas why this might be happening?

Any help would be appreciated.