Although I found a thread in this forum suggesting it could be done, I cannot open two databases with the same name at the same time. I need to do this to append files from an older table to a new table that may or may not have the same table structure.

I am using VFP 7.0 SP 1

I issue the commands:

OPEN DATABASE C:\IN\test.dbc
OPEN DATABASE C:\My Other Folder\test.dbc.

When I issue the SET DATABASE TO I only get the last database open as an alias of "TEST.DBC". If I specify a full path I get an error message that "database C:\IN\test.dbc" is not open.

Does anyone know of a way to open to identically named DBC's at the same time?