1

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
If this question can be reworded to fit the rules in the help center, please edit the question.

  • Maybe your computer has less free memory than the other one. – McNets Jan 31 at 18:47
0

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.