>I suspect Al's response hit upon what might have happened to you. When all my databases were created they were created under the Data directory and the tables were added new in the same directory. What you might want to do is use the GENDBC program to generate a program that will recreate all your tables and views. You can use this program to create the database and tables in another data directory. Then populate the tables with data from the original databases. Then try to move the new files around and see if you get the same problems.

Yes I think thats is it:)

It still seems a cumbersome way of doing it though.

The code I would like would be something I could run from within my app.

10 What folder is DBC in
20 What tables exist in the DBC folder
30 Now link each table in the folder to DBC


I have a tool that can do this but I can not run it from within my app. Also it seems to have problems unless I use drive mapping instead of UNC