2.6 verson of the table would be my guess too. So it sounds like this is now sorted out?

>I'm relying on my client to give me the correct information. He told me this was in 6. It's probably actually 2.6.
>
>The following works without error.
>
>Use < table > Exclusive
>Copy To < table in new directory > With Production Database Test
>
>>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 >