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 >