Help

  • Thread starter Thread starter Holly
  • Start date Start date
H

Holly

My company uses an access database designed by an outside
programmer. We no longer have contact with this man and I
am responsible for maintaining the program. When i went
to open it the other day it did not respond. I tried to
compress and it would not do it. When I checked the
properties of the database, it is still showing the
correct size but it seems to have disappeared. Any ideas?
 
Does your company back up the database nightly? We have a few Access databases that we've had corrupted. The only cost to fix it was the time to run the backup, and a few hours of data entry, which was easily recoverable.

Unfortunately, that's the only thing I can think of - but then again, most of the folks here are more skilled than me.

Derek

----- Holly wrote: -----

My company uses an access database designed by an outside
programmer. We no longer have contact with this man and I
am responsible for maintaining the program. When i went
to open it the other day it did not respond. I tried to
compress and it would not do it. When I checked the
properties of the database, it is still showing the
correct size but it seems to have disappeared. Any ideas?
 
Our backup was corrupted too. This is not the first time
that this has happened either. I was just wondering if it
was a common problem with Access. I had a copy of the
program on my desktop and was able to restore from that
but we had a months worth of data to re-enter. Has taken
us 3 days to restore the info.
-----Original Message-----
Does your company back up the database nightly? We have
Click to expand...
a few Access databases that we've had corrupted. The only
cost to fix it was the time to run the backup, and a few
hours of data entry, which was easily recoverable.
Unfortunately, that's the only thing I can think of - but
Click to expand...
then again, most of the folks here are more skilled than
me.
 
Ouch. That hurts. We were able to restore from an old backup one time - I think we had 3 days worth of data to get in there.

I believe that, if you have NT or something else that allows for scheduled backups, you can set up something like that. And elsewhere in the .macros discussion, someone mentions changing filenames to match dates. This might be a good idea and prevent overwrites. Compact your db first, or else it can grow pretty quickly and kill a bunch of file server space.

Good luck!
Derek

----- Holly wrote: -----

Our backup was corrupted too. This is not the first time
that this has happened either. I was just wondering if it
was a common problem with Access. I had a copy of the
program on my desktop and was able to restore from that
but we had a months worth of data to re-enter. Has taken
us 3 days to restore the info.
-----Original Message-----
Does your company back up the database nightly? We have
Click to expand...
a few Access databases that we've had corrupted. The only
cost to fix it was the time to run the backup, and a few
hours of data entry, which was easily recoverable.then again, most of the folks here are more skilled than
me.
 
i follow two rules: 1) always compact a db before
overwriting an existing backup; if it won't compact and
you can't fix it, then discard it and copy the backup as
your new "live" db - 98% of the time that will ensure that
you don't end up with a corrupted backup. 2) never open a
backup file directly. always make a copy of the backup and
work with the copy only. that way your backup file is
always "clean".
 
Back
Top