Exporting Updates

[GSC]

I maintain and update a database for which I have to send
regular updates via email another user. I am not sure
how to do this - I am having trouble setting up the
system so only updated information can be exported. Is
this possible? If so can anyone help?
Thanks in advance

 

[GVaught]

You need to split the database into two separate databases; the back-end
resides on the user's server machine and contains only the tables of the
database. The front-end resides on the user's machine and contains the
linked tables, queries, forms, etc. This is the ideal solution for updating
a database, especially if you have not modified the tables with new fields.
With this setup you can modify the front-end to your hearts content and
never touch the data in the back-end; nor have to worry about updating. If
you make changes to the back-end by adding a new field in a table, then you
only need to create an update db for the user to run to add the new field to
the existing design.