I am opening up a .mdb Access file in Access 2010. At some point in the past it got corrupted in some minor way where it won't allow me to delete or copy any objects (tables, queries, etc.)
This is not a read-only database. I can copy/delete tables programmatically. I can see all of the objects and every other function is available via the ribbon.
I have seen this phenomenon with other databases, both .accdb and .mdb.
In hunting around the internet, the only solution seems to be to create a new database and import all of the objects from the old database into the new database. But there are two problems:
1) This low-level corruption is happening quite often to a variety of databases. Creating new databases and importing is just too much overhead.
2) We have some linked tables that will not copy over. They are pointing to tables that have more than 2Gbytes of records in them. Because of an obscure error with ODBC and how Jet creates linked tables, there is no way create or copy a link that points to a table that has more than 2Gbytes of records. Links that pointed to tables before they grew beyond 2Gigs still work but creating new ones does not.
Does anyone know of any low-level Access properties that I can set to regain the ability to delete/copy objects?