Data Extraction Using ODBC

[brahmabull525]

I have been using MS Access to extract data using Make Table queries from several source tables in a separate software package using ODBC links. This works fine, with one exception. There is one large table (242,324 records) that I cannot extract data from. The Make Table query I'm trying to use "appears" to run, but upon completion I get the message "The search key was not found in any records".

I am using the described method on slightly smaller (high 100K record counts), identical tables successfully.

Does anyone have any experience with this type of issue? Is it because of the size of the table? Is there any way around it?

Any help would be most appreciated.

 

[Crowley16]

200k isn't that many records, it should work just as well as your 100k tables...

hows about showing us the code ur using and the table scheme...

--------------------
Procrastinate Now!