[AccessD] Mail Merge Start Second Copy of Access

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Fri May 9 09:00:13 CDT 2003


No. Well, maybe.  I load the FE on the server in the same folder with the
BE.  Then relink the tables.  Then drag the FE up to the clients' desktop
where they run it.  The mail merge table which is the data source for the
document is in the client FE.  Now, I'm thinking that the data source in the
document is pointing to the FE on their desktop. At least that's where it
was when I showed them how to make a data source for their docs.  However,
perhaps they have recreated the data source and are pointing to the FE on
the server.  Which would be bad if two of them tried to do a merge at the
same time.  I'll have to check that out.  Would that cause the second
instance of Access to start?

Thanks and regards,

Rocky

----- Original Message ----- 
From: "Andy Lacey" <andy at minstersystems.co.uk>
To: <accessd at databaseadvisors.com>
Sent: Thursday, May 08, 2003 11:55 PM
Subject: RE: [AccessD] Mail Merge Start Second Copy of Access


> Rocky
> The FE hasn't moved to a different location has it?
>
> Andy Lacey
> http://www.minstersystems.co.uk
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
> - Beach Access Software
> Sent: 09 May 2003 01:14
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] Mail Merge Start Second Copy of Access
>
>
> Dear List:
>
> I do a mail merge from an A2K app to Word.  The user selects the
> document to merge to.  They set the doc up before hand using as a data
> source a table in the app front end.  I put the customer name and
> address info in this table and it merges quite nicely into the word doc.
>
> But the merging opens up Access and the front end a second time.
> Doesn't really bother the user too much but they'd like to get rid of it
> if possible.  User insists it didn't used to do that and now it does.  I
> can't remember.  They're running Win2K and A2K.
>
> I speculated that it opened up the second instance because of the link
> to the front end table as the data source for the merge.
>
> anyway, is this normal?  Can it stopped?
>
> MTIA,
>
> Rocky Smolin
> Beach Access Software
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>




More information about the AccessD mailing list