Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Ensuring all processes are complete before continuing
Posted on 2016-10-21
I am writing a function via MS-Access VBA that generates several files and stores them in a folder (PDF, XLSX etc). It then creates an email and attaches all of the files within the specified folder (I am using EASendMail to do this). On my PC it works just fine, but I'm a little concerned that on a slower PC/network, Access (or the PC itself) may still be creating the files (XLS, PDF etc.) when the command to attach all of the files is issued (jumping ahead of itself).
Ideally, I'd like someone to come back to me and say that Access will not start work on the email/attach function until the previous processes have all finished, or before issuing the "oSmtp.AddAttachments" command, you should do x to ensure everything has been done.
I know I could check that the files in the folder exist before attaching (but if I don't have to do this, I'd rather not).
Ideally, I'd like someone to come back to me and say that Access will not start work on the email/attach function until the previous processes have all finished, or before issuing the "oSmtp.AddAttachments" command, you should do x to ensure everything has been done.
I know I could check that the files in the folder exist before attaching (but if I don't have to do this, I'd rather not).
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
2-
2
6 Comments
Active today
You can use a Transaction. You can manage transaction processing during a session defined by a DBEngine Workspace object -- for instance: start (BeginTrans), Rollback, and commit (CommitTrans)
here is a help page:
https://msdn.microsoft.com/en-us/library/office/ff835327(v=office.15).aspx
here is a help page:
https://msdn.microsoft.com/en-us/library/office/ff835327(v=office.15).aspx
Active 3 days ago
Thank you - That's a good idea, but I'm not too sure how to implement it (as I'm not writing data as such).
Ideally, it will be something like
Transaction begin
Create files
When files are actually sitting in the folder and everything is done
Transaction ends
Attach files from folder
Ideally, it will be something like
Transaction begin
Create files
When files are actually sitting in the folder and everything is done
Transaction ends
Attach files from folder
Active today
you're welcome
here is a help page for CreateWorkspace -- but I don't think you need to do that as there is a default workspace
https://msdn.microsoft.com/en-us/library/office/ff821374(v=office.15).aspx
btw, currentdb is like DBEngine(0)(0) -- just that currentdb is a pointer so more up-to-date when it is initialized
I think you can simply do something like this:
Set myDb = DBEngine.OpenDatabase(sNam
https://msdn.microsoft.com/en-us/library/office/ff193474.aspx
use db.execute
then either
DBEngine.CommitTrans
or
DBEngine.Rollback
here is a help page for CreateWorkspace -- but I don't think you need to do that as there is a default workspace
https://msdn.microsoft.com/en-us/library/office/ff821374(v=office.15).aspx
btw, currentdb is like DBEngine(0)(0) -- just that currentdb is a pointer so more up-to-date when it is initialized
I think you can simply do something like this:
Set myDb = DBEngine.OpenDatabase(sNam
https://msdn.microsoft.com/en-us/library/office/ff193474.aspx
use db.execute
then either
DBEngine.CommitTrans
or
DBEngine.Rollback
Active today
Transaction control has nothing to do with this. It only controls updates to the database, totally unrelated to external files.
Your only option is to keep track of the files in a loop, then proceed.
/gustav
Your only option is to keep track of the files in a loop, then proceed.
/gustav
Active today
You may be able to use the Sleep function here:
Modern/Metro style message box and input box for Microsoft Access 2013
Go to paragraph Simulating dialogue mode for code for a reliable loop that doesn't kill the machine.
/gustav
Modern/Metro style message box and input box for Microsoft Access 2013
Go to paragraph Simulating dialogue mode for code for a reliable loop that doesn't kill the machine.
/gustav
Featured Post
The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents. The steps to find the Templates folder path are …
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette.
This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month6 days, 15 hours left to enroll
623 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.