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.