Search Key Not Found error and Transferdatabase command

  • Thread starter Chris Davidson NGSS
  • Start date
C

Chris Davidson NGSS

I am trying to use the transferdatabase method to export a rather large table
to another database. When I use that method, I get "The search key ws not
found in any record" error. Whe I manually do the export I can do it with no
problem. Also when I trim up the ammount of records a bit (there are over
20000 records I am trying to export) to about 90 I can export OK. Does
Access have a limit to how much data it can transfer using the
transferdatabase method? Sort of seems a little strange to get an error like
that. Is it possible that a record can be corrupted even though the database
itself is not corruptted?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top