>>Hi all,
>> six months ago I took our large body shop app and used most of it as a base for a new system for jobber stores. It was too much of a pain to change the database name becase there were about 70 tables in it. Now, of course, I have some prospects that would like to run a combination of the two. That part is easy. Just look in one system from the other when needed. The hard part is I don't think I can have the same database name in two places and have them both open at the same time.
>>
>>I was wondering if anyone could give me some advice on the following:
>>
>>1. Can I have two databases with the same name open at the same time reliably. They reside in two different directories. (I assume no but...)
>>
>>2. I am assuming that the best way to rename the database is to use GENDBC and rework the generated code with the new database name. Is there an easier or more reliable way?
>>
>>Thanks all.
>>John.
>
>1) You can.
>2) I too think gendbc is easiest.
>Cetin

Cetin and Caroline,
many thanks for the advice. I forgot to mention that, because they started out as the same system, most of the tables in both databases have the same name. Becuase of that I have decided to use GENDBC and rename the database in the new system. It might be painful but I'm sure it's something I will be glad I did.

John.