I'm developing an application in MS Access that has to merge print
various documents (approximately 50 documents per day).
I have written a function to identify if MS Word is executing so I won't
execute a second instance, and have been able to identify and overcome
most problems.
There are though, two things that worry me:
1) This merge print operations are extremely slow. If there is any way
to improve speed with automation, please let me know, and
2) What worries me the most is that every time the program merge prints
it prompts the user for user name and password. This is really annoying
as you may expect, and I haven't been able to overcome this.
Is there any way to let MS Word know that the data source to be merged
is located in an already executing MS Access database?
I'm working under Windows NT 4.0 and Windows 95.

Thanks in advanced,

Mario Osorio
Venezuela