I am actually writing an application that needs to interact with a software called Visual Account Mate (which is written in VFP). Everything works fine but one thing, adding new records. My problem is caused by the presence of a general field in the table I am accessing.

I need to use ODBC because I need to access the table while other users are still logged in; accessing the tables directly wont let me do that. Now, without ODBC I can add new records even though I have a null value in the general field. However, with ODBC, an error occurs saying that the general field does not accept null values. (by the way, I use the VPF driver for my data source)

So I tried to put SPACE(10) as the default value in the field(a developer from Account Mate suggested me to do so). However, I cant even use APPEND BLANK without getting an error. If I use INSERT INTO, the new record gets created, but I still get the error message. If I handle the error I can create new records. However, when I use INSERT INTO in a program, it generates the error 'Data Source is Busy'. I can use it from the command window, but not from a program.

Can anyone help me?