Yeah.

Thanks for the input. It pushed me in the right direction to find a solution.

Dan

>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 >