I am new to Visual Fox Pro 5 and can use some help.
I have a program that gives me error message:

ODBC Error Code = S0002 (Base table not found)

[Microsoft][ODBC Visual FoxPro Driver]Not a table.


SQL = "SELECT * FROM categoryrec WHERE code NOT LIKE 'WH%' ORDER BY name, code ASC"

Some work just fine and some give me this error message.
I have many .DBF files in this program and 1 .DBC file.
This is unlike what I am used to with the MS Access only having one database file. I am not really sure whats wrong as I only have MS access and it won't view the VFP stuff. I wonder how hard it would be to convert these files to one MS Access data base or if I could just get these to work that would be great also.

Any help would be great.

Thanks