Automatic Email

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to set up a program so when the user closes it, it sends me the
saved copy of the updated information. If anyone has any ideas I would
appreciate it.

Donbenz
 
If I understand you correctly, you want to have the entire database file
emailed to you. if so, then:

The only thought that I had was that you might set up a second database file
that would be open all the time (or use the Windows scheduler and schedule it
to open on a regualar basis) and have this database file check the folder
where the original database is located to see if it has been modified (file
data has changed) and also check for the existance of the .ldb (lock) file.
If the date has been changed and the .ldb file is not there then you would
know that the user had opened and closed the database. If the .ldb file is
not there then the file is not open. You could then have this second
database file email you a copy of the updated database file.

This may be a crude way of accomplishing what you want, but I could not
think of any other solution, if you want the entire database.

If on the other hand you only need the updated data, you could just have
that application send you an extraction of the modified data.
 
It really depends on the kind of updated information you want. In the case
of a new customer or a few updated records you might create a query or series
of update queries generating a report of the information which could then be
sent to you using SendObject. All these actions can be attached to a command
button that also closes the application when the user is finished.
 
Back
Top