Database Backup

G

Guest

I have a database that I want to backup and it wont let me. It is password
protected with the standard Access Protection and I have full admin rights
and as far as I can find permission to do anything (I wrote it). But I keep
getting the following errors. Can I back this up or should I just copy the
files to a backup location?

Thanks for the help.
David
1) "Could not read definitions; no read definitions for table or query
‘~TMPCLP203831'."

"You do not have the necessary permissions to use the ‘~TMPCLP203831’
object. Have you system administrator or the person who created this object
establish the appropriate permissions for you."

2) "Could not read definitions; no read definitions for table or query
‘~TMPCLP227261’."

"You do not have the necessary permissions to use the ‘~TMPCLP227261’
object. Have you system administrator or the person who created this object
establish the appropriate permissions for you."
 
R

Rick B

How are you backing it up? Can't you just open Windows Explorer and
right-click the file, select copy, then open the backup folder and select
"paste"?
 
J

Joseph Meehan

DDrowe said:
I have a database that I want to backup and it wont let me. It is
password protected with the standard Access Protection and I have
full admin rights and as far as I can find permission to do anything
(I wrote it). But I keep getting the following errors. Can I back
this up or should I just copy the files to a backup location?

Exactly how are you trying to back it up?

Have you considered just copying the mdb or mde file?
 
G

Guest

That's what I ended up doing. I was trying to use the "Back up Database"
command that is in MS Access and it didn't work.

Guess the easyiest thing will be to just copy it. Just trying to use the
tools provided.

Thanks
 
P

Pieter Wijnen

Do a Compact on the db
or attempt
Docmd.DeleteObject [acQuery]|[acTable],"~TMPCLP203831"
 
J

Joseph Meehan

DDrowe said:
That's what I ended up doing. I was trying to use the "Back up
Database" command that is in MS Access and it didn't work.

Where is that command and what version are you using?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top