Creating a back up

[Jason]

I'm trying to create a back up of my Access database and I am unable to do
so. I've created back ups in the past, but starting yesterday, I can no
longer create one. I do not receive an error message, but after the Save As
window closes and I check the location where I tried to create the back up
copy, it is not there. As far as I know, nothing has changed about the
database as far as security, etc. Any help with this issue would be
appreciated.

 

[Golfinray]

Go to tools/database utilities/compact and repair. Run that first. Then go to
file/backup database and try there.

 

[Al Campagna]

Jason,
"SaveAs/Export" is for individual objects within the database, not for
backing up the entire .mdb file/s.
Access "backup" is done from outside Access, and involves just making a
copy of the .mdb file/s to whatever storage device you use.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Jason]

Thanks for the reply. I tried the compact and repair, but it doesn't look
like that is working either. It briefly says "Removing Temporary Objects" in
the lower right corner of the screen and then that message goes away and
nothing else happens. No error, warning or other message. Should I get a
message saying the compact and repair is complete if it is successful?

 

[Golfinray]

Yes, you should get a message. It sounds like you may be hosed. If you have
any code, go into the code editor and de-complie it. Sometimes that will hang
you up. I hope you have a backup copy.