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 >