I created a small scheduling system that involved complex forms and reports. This system was sent to a client and is now hosted on their network. They have requested some updates and new features to be added to the existing forms. I have made those changes on my copy of the original database, but now need to email them the NEW (updated) forms, but didn't want to resend the entire database (they have already begun using/entering data into the tables). Is is possible to email just a single form or report that they could then import into their existing database?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Email Access 2000 Forms as attachments
- Thread starter StephDN
- Start date
If you originally created the database in two parts namely tables as the backend and your forms, reports, queries, etc as your frontend, all you have to do is email the frontend and install it on your target location and run link table manager to ensure the connection is there. If you didn't you will probably have to run the Database Splitter to get it to work.
If you have savvy end users then you could let them install updates... but I wouldn't leave this type of update to them.
Either way BEFORE YOU START make backup copies of everything!!!![[thumbsup2]](/data/assets/smilies/thumbsup2.gif "[thumbsup2] [thumbsup2]")
Create a new database and call it TRAVEL or whatever you want.
Navigate to the forms section and right click in the database window. Choose ||IMPORT|| and navigate to your current database location. Select the form(s) using the control key, and import them into your new database. Repeat this in the users database (if the form names are consistant then it will copy them in with a number appended to the end of the form name: frmUserInformation would become frmUserInformation1 for example).
Then you can pick and choose what to update by renaming the originals as a backup: frmUserInformationBAK for example and then change the name of frmUserInformation1 to frmUserInformation. This should update the database to include any changes that you made in the form WITHOUT affecting records. If you have changed ANY information about field names or associations then you will need to make the changes to your existing table structure or you will have a mess.
My advice is to DOCUMENT DOCUMENT DOCUMENT every step you make.
It is much easier to do then to explain..
Good luck, hope this was helpful JerseyBoy
Remember: self-praise is no recommendation
Either way BEFORE YOU START make backup copies of everything!!!
Create a new database and call it TRAVEL or whatever you want.
Navigate to the forms section and right click in the database window. Choose ||IMPORT|| and navigate to your current database location. Select the form(s) using the control key, and import them into your new database. Repeat this in the users database (if the form names are consistant then it will copy them in with a number appended to the end of the form name: frmUserInformation would become frmUserInformation1 for example).
Then you can pick and choose what to update by renaming the originals as a backup: frmUserInformationBAK for example and then change the name of frmUserInformation1 to frmUserInformation. This should update the database to include any changes that you made in the form WITHOUT affecting records. If you have changed ANY information about field names or associations then you will need to make the changes to your existing table structure or you will have a mess.
My advice is to DOCUMENT DOCUMENT DOCUMENT every step you make.
It is much easier to do then to explain..
Good luck, hope this was helpful JerseyBoy
Remember: self-praise is no recommendation
- Status
Similar threads
