Try to access the .dbf file directly without importing it into access. Once you are attached, all SQL commands are available. >Why does it stop after 31,469 records ... Show the code. You should have access to all the records. BTW, .dbf files come in many versions, do you know what version you are working with ? Noel
Chris Hagwood <[EMAIL PROTECTED]> wrote: In a related question, I am trying to make use of a dbf file, but I'm not able to do much with it. When I copy it locally, I can "link" it in Access. I cannot import it into an Access table, I get an error. [unexpected error from external database (10019)] Once linked in Access, it seems to work OK, but I still cannot seem to get a full copy of the data in Access format. I have tried a "make table" query in Access, and it errors out, with the same [unexpected error from external database (10019)] I have tried to open the dbf file, and copy all the records one at a time from an ASP script. It appears to function normally, but only gets 31,469 records. There are many, many more. When I try to query it (the dbf file) in ASP, it won't work. If I put any sort of "WHERE" clause, I get the following error message any time I try to query the db directly: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] The search key was not found in any record. Why does it stop after 31,469 records in the only script that appears to work? --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups SponsorADVERTISEMENT --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- Do you Yahoo!? Meet the all-new My Yahoo! � Try it today! [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
