Great! Is everything working now ? You need to go back to the source DB, find that record and fix it too. Noel
Chris Hagwood <[EMAIL PROTECTED]> wrote: Well, in googling the error I was getting, it seemed to be associated with corrupt data. Then, I was able to sort the linked table by every column but [DATE]. When sorting one of them, I saw a record with "Error#" in the [DATE] field, so I deleted that record. After that, everything started working. So, I figure the bad record was preventing the ODBC connection from working properly. ----- Original Message ----- From: "Noel Reynolds" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 18, 2004 10:47 AM Subject: Re: [ASP] dbf file woes How did you know there was a bad record ? Chris Hagwood <[EMAIL PROTECTED]> wrote:OK, I solved my own problem (that seems to be the case 50% of the time, just posting to this groups seems to awaken certain brain cells that tell me where to look) There is a corrupted record in the .dbf file. If I get the file open while linked in Access, delete the bad record, then close it, I can then query the .dbf file directly. Only problem is, I'm working with a local copy, and every time I copy over an updated version, it still has the bad record in it. I'm going to try to get the other system to correct the bad record on the original so I can automate the process a little more. > 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. --------------------------------------------------------------------- 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] --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links --------------------------------------------------------------------- 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!? The all-new My Yahoo! � Get yours free! [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/
