Exporting Updates

  • Thread starter Thread starter GSC
  • Start date Start date
G

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
 
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.
 
Back
Top