What Access VBA code would I use to automatically email all Access tables as Excel spreadsheets
via Outlook without the user being able to alter the data. So I want the emails to fire off straight away.
Thanks
Microsoft AccessVBAMicrosoft ExcelMicrosoft Office
Last Comment
Murray Brown
8/22/2022 - Mon
Rob Henson
Any data when it has been separated from its source is open to amendment unless it is protected in some way.
I don't know how you do it but would suggest you create a Front End Viewer that you distribute to users. I believe a Front End Viewer enables users to view the data and/or reports without having access to the actual data so can't amend it.
Bill Prew
Do you mean you don't want them to alter the data in Access, or in the email?
If the latter, and you are attaching it as an Excel workbook, then you could protect that against modification with a password, etc.
I don't know how you do it but would suggest you create a Front End Viewer that you distribute to users. I believe a Front End Viewer enables users to view the data and/or reports without having access to the actual data so can't amend it.