I found that with a pre-Access 2010 database opened in Access 2010, you can’t copy and paste a table. I use this function to backup a ‘reservations’ table before clearing it out to start a new round of reservations. The common accepted solution is to create a new database, but at this point I am not willing to do that (since I’m not ready to test compatibility). So here was my posted solution:
My last solution was to do an EXPORT (External Data->Export->Access) and select the current database as the destination. Then just select a new table name.
It’s obviously not as easy as the good old Copy/Paste, but I am also unwilling to create a new database for this one project and I haven’t seen any other solutions.
Access 2010 – Windows 7 o/s – Paste and Delete options disabled – Microsoft Answers.
