Could be a naming conflict with ODBC ("level") ... Assuming you are working with the data via a remote view, could be that the Integer field is not being interpreted correctly. In either case, you can always use AERRORS() to get the specific ODBC error.
>I'm using Visual FoxPro to build a program to maintain the data in MS Access database. I have the following fields in the table called "glacctcode" :-
>1)Acctcode char(10)
>2)Descrip char(50)
>3)Level integer
>4)Type char(15)
>5)Category char(15)
>6)Expdate date/time
>
>The primary key is Acctcode.
>
>After I build a maintenance program for this table, and try to enter the data, my program always return an error "1526", and I'm not able to save the data. But when I took away the LEVEL field from my program, it is OK. Why?
>
>Thank U in advance.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05