MS Access Bizarre Paste Problem
I have a database that requires me to copy data from a spreadsheet into a corresponding table in Access. Its a .mdb created in 2003 but I use 2007.
Ive never had a problem before, but today when trying to update the table with new data I was getting this error:
Ive never had that before, and have done this same procedure without a problem for over a year and a half now.
It did let me paste into a new table, and then from that new table to my existing table, but just not directly into the existing table.
Tried it on a few machines as well with the same problem, and even tried a few various backups of the database too to see if something had corrupted somewhere along the lines.