Hi, All

I am in the process in developing a new version of my software. I have changed my design of my database slightly (added a few new tables and new fields to existing tables). The issue is that my users have user data in the old Db that I would like to transfer to the new Db. Both Db's are access 2003. Because my software is distributed over a wide geographical are it would not be possible to do this manually

I have appended data between two different tables in a single Db, but not between two separate Db's.

Can someone please assist, sample code would be appreciated
I have searched the threads but have no success.

Thanx