Kevin,
Larry's right. You either have to allow for a NULL value in each of the other fields, or you have to give them a default value. There is no way around this. And, I'll point out that you'll face this exact situation in SQL Server, so if you spend the time now to make the necessary changes, it will save you a huge headache later down the road when you either attempt to move the current application to SQL Server or write an application that uses SQL Server from the start.
HTH,
Travis
>this presents a real problem. I'v been coding ADO into my application
>for 2 days now, and the tables i'm using are in place for multiple
>applications. I cannot just arbitrarily alter the structure of a table
>to meet ADO's requirement.
>
>Is there no way to add a record without having to fill in ALL the field
>values?
Travis Vandersypen