Can't delete or paste db objects

Brando

Enthusiastic Novice
Local time
Today, 05:53
Joined
Apr 4, 2006
Messages
100
I just upgraded to Access 2010. I can't delete or paste database objects in the table, form, query lists, etc.. Is there a setting that allows this? :banghead:
 
Are you using keyboard shortcuts or the File a Menu?

Is the db opened exclusively or could it be read only?

Have you tried between multiple dbs or is this in the same one?

Can you copy/paste single records?

Is the db in a trusted location, or has it been enabled. Did the warning bar appear along the top?
 
Thank you for offering to help. See my answers below...

Q. Are you using keyboard shortcuts or the File a Menu?
A. I'm right clicking on an object to delete it. The delete option is not
available. Also, I can rename it and copy it, but can't paste it.
Q. Is the db opened exclusively or could it be read only?
A. I have exclusive access to the database. Other users are logged out.

Q. Have you tried between multiple dbs or is this in the same one?
A. I have three Access dbs. Two of them are behaving this way since
the upgrade to Access 2010.
Q. Can you copy/paste single records?
A. Yes.

Q. Is the db in a trusted location, or has it been enabled. Did the warning bar appear along the top?
A. The db is in a trusted location. The warning bar doesn't appear.
 
Hmm that is odd then.

You could try a compact and repair, worth a try for any error, just in case!

If that doesn't work try a blank db then use the import wizard to transfer the objects across, then try manually again.
 
I had already tried the compact and repair. I'll have to give the blank database and import wizard idea some thought. What's really weird is that it's happening in two of the three dbs.
 
Oh Good Lord! I set up a blank db and used the import wizard. Unfortunately, the db I'm importing from has security, so most of the objects can't be imported into the new db.

But again, most of my databases are acting this way (not allowing objects to be pasted or deleted. Could this have something to do with the upgrade to Office 10?
 
What version did you originally to have?

Have you tried repairing office?
Uninstalling/Reinstalling?
Check you have the Latest SPs.

What Security did you have on it?
Could you remove the Security?
 

Users who are viewing this thread

Back
Top Bottom