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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Send Backend database by email

Status
Not open for further replies.

Geraldo

Programmer
Mar 18, 2002
37
PT
i´m in the front end database and i want to send an email with the backend database attached automaticaly.

Geraldo
 
You've got a few problems doing this. The first would be that you probably have some of the backend tables locked when the front end is open. That would most likely provide you an error if you attempted to attach it to an Email. Secondly, Outlook, and many more Email clients, will not deliver attachments with an extensions matching Access files. This would force you to package it in some other, more acceptable way; like removing the extension or compressing the file into a .zip container file. You can't do this normally without some additional software or some very imaginative design.

1) Identify the location of the linked database.
2) Package the database
3) Attach the file to the Email using (SendObject or COM or Automation)
4) Perform error checking all the way.


-------------------------------------
scking@arinc.com
Try to resolve problems independently
Then seek help among peers or experts
But TEST recommended solutions
-------------------------------------
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top