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 >