R
rocketD
Hello,
I have a mail merge template in Word that I've been using with
Access. Now I'm trying to automate it. I have seen the suggestions
for code from Albert Kallal and Ken Sheridan, but I already developed
my own form with the thought I could just open the merge file with
simple code on a button. The problem is, I get an error message when
the Word file opens using the button, saying that the data file cannot
be locked because it's in use by 'Admin' (me). I tried splitting the
database (figuring if multiple users can access it at once, then
applications could too) but I get the same error.
Does anyone know if there's a setting I can change to get around
this? If not, I will use the MVPs' code I mentioned above, but it
will take me a long time because I'm such a newb to coding and it
might be better to just do it manually.
Thanks,
Dara
I have a mail merge template in Word that I've been using with
Access. Now I'm trying to automate it. I have seen the suggestions
for code from Albert Kallal and Ken Sheridan, but I already developed
my own form with the thought I could just open the merge file with
simple code on a button. The problem is, I get an error message when
the Word file opens using the button, saying that the data file cannot
be locked because it's in use by 'Admin' (me). I tried splitting the
database (figuring if multiple users can access it at once, then
applications could too) but I get the same error.
Does anyone know if there's a setting I can change to get around
this? If not, I will use the MVPs' code I mentioned above, but it
will take me a long time because I'm such a newb to coding and it
might be better to just do it manually.
Thanks,
Dara