I have an mdb file that has some large tables in it (greater than 65000 rows). I used to not have any problems duplicated the table by copying and pasting but just recently I started getting a message about the size of the clipboard not being able to hold more than 65000 lines. What's weird is the operation works on another computer with the same version of Access (32bit 2010) and the same table and doesn't report this error message. It just started reporting this message on the "problematic" computer recently, and nothing has changes as far as I know except for Windows automatic updates. Any help appreciated.
closed as off-topic by hot2use, mustaccio, McNets, Colin 't Hart, Philᵀᴹ Feb 2 at 18:47
This question appears to be off-topic. The users who voted to close gave these specific reasons:
- "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – hot2use, McNets, Philᵀᴹ
- "This question does not appear to belong here. Either it's not database-related or it otherwise conflicts with the scope of our site. See What topics can I ask about here?, What types of questions should I avoid asking? or this blog post for more info." – mustaccio, Colin 't Hart
What's wrong its trying to copy such amount of data (straight from a table, mind you) to the Clipboard. But since this is Access we're talking it wouldn't shock me that's suggested over Exporting the data safely into a format like .CSV or Even better .SQL Is funny that you mentioned the system architecture because on first sight I would check that as possible cause.
I would highly suggest changing the approach into something more around this lines: https://support.office.com/en-us/article/Introduction-to-importing-and-exporting-data-08422593-42dd-4e73-bdf1-4c21fc3aa1b0