Search results

Okay, I'm an idiot. The error came from a custom validation on one of the other fields and the default value wasnt valid. Thanks for somehow pointing me in the right direction.

Okay, I'm an idiot. The error came from a custom validation on one of the other fields and the default value wasnt valid. Thanks for somehow pointing me in the right direction.

Ok, sorry, I forgot to mention that I got the same error message when I commented the editting of the VisitID field. SO that doesn't seem to be the source of error IMO. VISIT_ID is a long integer in the access DB. It is the primary key of the 'Threshold_Test' table, so yes, it is indexed and...

Re: Importing multiple Text files with "Field Name: Field Value" into a Table I'm affraid the automatic functionality in Access to import textfiles works like a comma separated file. In your example the data is on different rows, so that probably won't work. I suppose you could 'parse' it...

Hello, I am coding on a vba program to load an XML file into an(other) access 2003 database. I'm putting the data in 4 tables now, which worked fine for the first three tables (using AdoDB.Recordset). On updating the 4th Recordset Im getting a very vague error. I already toggled all code that...