Hi. I have written a bunch of asp's to manage an Access database. It has been working fine until I had an 'Unrecognized database format' error appear on the webpage. After this the database becomes corrupt and unusable.
Upon investigation using a back up database it seems that a loop that inserts records one after another is the problem. When I run this loop the records show as #Error in each field.
However upon further investigation I get the same problem when manually adding records to the table when in Access. Each time I enter values for record 2006 then records 1147,2001 to 2005 show as #Errors. Bizarre!! And I get an 'Invalid Bookmark' error that keeps popping up after the errors appear.
Any ideas? Many thanks in advance.
Modalman
ASCII silly question, get a silly ANSI
Upon investigation using a back up database it seems that a loop that inserts records one after another is the problem. When I run this loop the records show as #Error in each field.
However upon further investigation I get the same problem when manually adding records to the table when in Access. Each time I enter values for record 2006 then records 1147,2001 to 2005 show as #Errors. Bizarre!! And I get an 'Invalid Bookmark' error that keeps popping up after the errors appear.
Any ideas? Many thanks in advance.
Modalman
ASCII silly question, get a silly ANSI