Send Backend database by email

[Geraldo]

i´m in the front end database and i want to send an email with the backend database attached automaticaly.

Geraldo

 

[scking]

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
-------------------------------------