Do you support clients who paste data directly into Access tables? If so, you probably often get calls from users who receive a message that Access is adding data to the Paste Errors table when they’re trying to paste. When that happens, you can usually explain and resolve the problem pretty quickly by considering all the usual suspects.
When you hear, “Some of the fields are missing,” chances are good that the user tried to paste more fields than the datasheet contains and Access ignored them. Users who are in a hurry will try to paste without selecting destination fields or try to paste into the wrong destinations.
Dirty data is a frequent cause of paste errors. If the data layout of the Access table has changed (and no one told the user), or if the layout of the foreign file changed (and no one updated the Access table), then values may get kicked out if they’re not compatible with the data type for the field in which they attempted to land.
Access may also reject records for dozens of other reasons, such as violating validation rules. For users who frequently paste data from other sources into their datasheets, the best advice may be: Make a clean backup copy of your table before you paste, just in case.
What do you think of this article format?
Our editors are developing and refining new methods and formats for delivering the solutions you need. Do short tips such as this one help you overcome the IT problems that keep you up at night? Share your thoughts with our editors; you could win a free TechRepublic book or CD of your choice. Content for this article was derived from the TechRepublic Microsoft Office e-newsletter. You can have tips like this delivered via e-mail each week by signing up here.