Thanks a lot Mark. Very helpfull.
Eric
>>What would be the best way to merge two databases into one?
>>Can I just copy & paste from a database to another without any problem?
>>
>>thank you
>>eric
>
>Here is what I would do:
>
>1. Backup everything from the first DB.
>2. Open the second database and DO HOME() + "Tools\Gendbc\Gendbc"
>3. Close the second database.
>4. Open the first database.
>5. Run only the part of the code generated by gendbc to create the objects [e.g., tables, views, connections, relations, etc.] from the 2nd DB that are NOT in the first DB.
>6. Open each new table and APPEND FROM the same table in the second DB.