make changes to a user's database 1

[ElSteveO]

I created a database for a user. He has added many records. He requested some new forms and reports, which I created on my copy at home. How do we keep all the new records he entered and import them into the new database structure?

 

[THWatson]

ElSteveO
I'm assuming that the user's copy and your copy at home have the same name. Therefore...

1. Rename the user's copy by adding (old) to the end of the database name.
2. Copy your new database to the user's computer and open it.
3. Import his tables into your new structure, by clicking on the File menu, then Get External Data, then Import.

If you have table objects of the same name still in your copy, you will see that the new tables imported from your user's database will have 1 added to the end (e.g. tblFred, tblFred1)

You can then rename tblFred to (old), and remove the 1 from tblFred1, and things should run properly.

By the way, you may want, at some point, to consider splitting the database into a Front End and Back End. Then when you make changes to the Front End, such as you have done now, all you have to do is copy the new Front End onto your user's computer and re-link the Back End.

Hope that helps.

Tom

 

[ElSteveO]

Thanks for the great advice!
Steve