Occasionally when I copy/paste a range of data from Excel 2010 into Access 2010 to create a new table the operation fails. After failing, the database no longer allows me to delete objects or copy/paste objects.
The only workaround I have found for this is to create a blank database and then import all of the objects from the "corrupted" database into the new one.
Has anyone else experienced this? Is my DB truly corrupted or did some settings/permissions get reset? If so, is there a way to set them back so I can delete/copy/paste DB objects once again?