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 >