> Hello there,
>     I have established an ADO connection to a Microsoft Access database
> called users.mdb and I am trying to do the following SQL update
>     SQL = "INSERT INTO profiles (mEmail, mGender, mHobbies, mLevel,
> mLocation, mMarital,"
>     SQL = SQL & "mName, mOccupation, mPicture, mQuestion, mUserid,
mUserreg,
> mPassword, mAnswer)"
>     SQL = SQL & "VALUES ('"
>     SQL = SQL & mEmail & "', '"
>     SQL = SQL & mGender & "', '"
>     SQL = SQL & mHobbies & "',"
>     SQL = SQL & mStatusLevel & ", '"
>     SQL = SQL & mLocation & "', '"
>     SQL = SQL & mMarital & "', '"
>     SQL = SQL & mName & "', '"
>     SQL = SQL & mOccupation & "', '"
>     SQL = SQL & mPicture & "','"
>     SQL = SQL & mQuestion & "', '"
>     SQL = SQL & mUserID & "', "
>     SQL = SQL & mRegisterUser & ", '"
>     SQL = SQL & mPassword & "', '"
>     SQL = SQL & mAnswer & "')"

>     The table in the users.mdb is called profiles but when I try to
execute
> the SQL on the database I am getting an error back and the err.description
> displays [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect
>     Can someone tell me why please? There is not a COUNT field present at
> all in the database structure, I have tried to rebuild the database,
repair
> and reconstruct but it still comes back with this.
>     I am at my wits end, any one any ideas?

> --
> Thank you for your time
> Anthoni Gardner
> Born2Code Software
> http://w3.to/born2code