Try doing a SELECT * FROM oldtable INTO TABLE newtable before you try adding the tables to the DBC.

>I just did try it with a memo field. Made no difference. BTW, I get 48 for SYS(2029), with or without a memo field. 245 is not VFP6 table, it's some other version.
>
>
>>Create the table with a memo. Maybe that's part of the problem.
>>I'll email the tables.
>>
>>>If you do, I won't be able to look at them until later. I can't access that email address from work.
>>>
>>>>These are all free tables.
>>>>Can I email you the files? :)
>>>>
>>>>Dan
>>>>
>>>>>Are your table already part of a some other database? If that's the case, you'll have to free them before you can add them to your new database.
>>>>>
>>>>>
>>>>>>You still have to be opening the table somehow.
>>>>>>
>>>>>>I just did the same program and created the tables in VFP6, and run just the add table part in VFP9, and no messages.
>>>>>>
>>>>>>
>>>>>>>Fred-
>>>>>>>
>>>>>>>I just tried one table.
>>>>>>>
>>>>>>>I copied the table that was created in VFP 6.0 to a DataTest folder.
>>>>>>>In the command window I typed
>>>>>>>
>>>>>>>CLOSE ALL
>>>>>>>CLEAR ALL
>>>>>>>CREATE DATABASE Test
>>>>>>>ADD TABLE WsCans
>>>>>>>The error still occured.
>>>>>>>The problem with the code below is that I would be creating the tables in VFP 9.0 not in VFP 6.0.
>>>>>>>
>>>>>>>If you don't mind I can email you the three files for this one table.
>>>>>>>Then we can verify the error on your side.
>>>>>>>
>>>>>>>Dan
>>>>>>>
>>>>>>>
>>>>>>>>Then you must be opening the tables in some other manner. Does this work without error for you? It does for me.
>>>>>>>>
>>>>>>>>

CLOSE DATABASES ALL
>>>>>>>>
>>>>>>>>CREATE TABLE t1 (f1 c(1))
>>>>>>>>USE IN SELECT("t1")
>>>>>>>>CREATE TABLE t2 (f1 c(1))
>>>>>>>>USE IN SELECT("t2")
>>>>>>>>CREATE TABLE t3 (f1 c(1))
>>>>>>>>USE IN SELECT("t3")
>>>>>>>>CREATE TABLE t4 (f1 c(1))
>>>>>>>>USE IN SELECT("t4")
>>>>>>>>CREATE TABLE t5 (f1 c(1))
>>>>>>>>USE IN SELECT("t5")
>>>>>>>>
>>>>>>>>CREATE DATABASE test
>>>>>>>>
>>>>>>>>ADD TABLE t1
>>>>>>>>ADD TABLE t2
>>>>>>>>ADD TABLE t3
>>>>>>>>ADD TABLE t4
>>>>>>>>ADD TABLE t5
>>>>>>>>
>>>>>>>>

>>>>>>>>
>>>>>>>>>Fred-
>>>>>>>< snip >