Thankyou Sergey

I have added an autoinc field to that table which would be causing the problem. Are their any other options to use in this case, where I will probably want to upsize later ?

Regards
Darren


>VFP ODBC driver doesn't support any new features introduced after VFP6, like DBC events, AutoInc fileds, e.t.c.
>
>>VFP9
>>
>>I haven't used a VFP database for a long time, but am using it for this new project. I am accessing the database via ODBC so I can upsize the database later, but I am having trouble with one table. Every time I modify it, add a fields etc, then try and access it with odbc eg 'select * from table1' and sqlexecute, I am getting the error 'Not A Table'.
>>
>>But if I open the database in VFP, and use the table, it is fine. Other tables in the databse don't seem to be a problem, but they haven't been modified either.
>>
>>Would anyone know what I am doing wrong with this table to cause this problem.
>>