By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,486 Members | 1,749 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,486 IT Pros & Developers. It's quick & easy.

Mailmerge from MDE not working

P: n/a
I have a mailmerge that works fine from an MDB database using the
OpenDataSource method to send its data from a query within Access as part of
an automation sequence. Now, if I compile that mdb into an MDE, when I
click a button on the Access form that should produce the mailmerge, the
template opens on the screen with the fields visible, then an error message.

"File in use. <Filename> is locked for editing by 'another user'."

I then have to shut the Word document down and when I return to the Access
App form, the Microsoft Access Error "Word is unable to open the data
source." is visible. I have previously run mailmerges by the
DoCmd.TransferText method and had the mail merge main document find the
small textfile produced with the data in it, but I want to use this
OpendDataSource method to send out the name of the query in Access where the
merge data is to be found.

The query works fine. What seems to be stopping it from working is that it
sees the MDE as being locked for editing by another user (but it is OK if it
is an MDB) There must be something I am missing here and I can't believe it
hasn't happened to others.

If you have run into this before could you please explain why this is
occurring?
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
I reckon the best way forward to debug this is to see whether you can create
a mail merge against the MDE file "by hand" ie. from within Word itself
interactively, both with the MDE opened and with it not opened.
This will enable you to test your assumption of whether the opened MDE is
somehow locking you out of the data.
Once you can do it by hand, then you should be able to do the same thing
using automation.

Ian.

"Dixie" <di***@dogmail.com> wrote in message
news:43********@duster.adelaide.on.net...
I have a mailmerge that works fine from an MDB database using the
OpenDataSource method to send its data from a query within Access as part
of an automation sequence. Now, if I compile that mdb into an MDE, when I
click a button on the Access form that should produce the mailmerge, the
template opens on the screen with the fields visible, then an error
message.

"File in use. <Filename> is locked for editing by 'another user'."

I then have to shut the Word document down and when I return to the Access
App form, the Microsoft Access Error "Word is unable to open the data
source." is visible. I have previously run mailmerges by the
DoCmd.TransferText method and had the mail merge main document find the
small textfile produced with the data in it, but I want to use this
OpendDataSource method to send out the name of the query in Access where
the merge data is to be found.

The query works fine. What seems to be stopping it from working is that
it sees the MDE as being locked for editing by another user (but it is OK
if it is an MDB) There must be something I am missing here and I can't
believe it hasn't happened to others.

If you have run into this before could you please explain why this is
occurring?

Nov 13 '05 #2

P: n/a
I tried this Ian and when I try to nominate the database that I want the
data link with, and then choose MS Acess Database (*.mdb; *.mde), I get an
error that says "Word cannot re-establish a DDE connection to Microsoft
Access to complete the current task." I have done an extensive internet
search on this and have not turned up anything helpful at this stage.

dixie

"Ian Hinson" <pp******@bigpond.net.au> wrote in message
news:pT******************@news-server.bigpond.net.au...
I reckon the best way forward to debug this is to see whether you can
create a mail merge against the MDE file "by hand" ie. from within Word
itself interactively, both with the MDE opened and with it not opened.
This will enable you to test your assumption of whether the opened MDE is
somehow locking you out of the data.
Once you can do it by hand, then you should be able to do the same thing
using automation.

Ian.

"Dixie" <di***@dogmail.com> wrote in message
news:43********@duster.adelaide.on.net...
I have a mailmerge that works fine from an MDB database using the
OpenDataSource method to send its data from a query within Access as part
of an automation sequence. Now, if I compile that mdb into an MDE, when I
click a button on the Access form that should produce the mailmerge, the
template opens on the screen with the fields visible, then an error
message.

"File in use. <Filename> is locked for editing by 'another user'."

I then have to shut the Word document down and when I return to the
Access App form, the Microsoft Access Error "Word is unable to open the
data source." is visible. I have previously run mailmerges by the
DoCmd.TransferText method and had the mail merge main document find the
small textfile produced with the data in it, but I want to use this
OpendDataSource method to send out the name of the query in Access where
the merge data is to be found.

The query works fine. What seems to be stopping it from working is that
it sees the MDE as being locked for editing by another user (but it is OK
if it is an MDB) There must be something I am missing here and I can't
believe it hasn't happened to others.

If you have run into this before could you please explain why this is
occurring?


Nov 13 '05 #3

P: n/a
See if this can help:
http://support.microsoft.com/default...b;EN-US;291445

"Dixie" <di***@dogmail.com> wrote in message
news:43******@duster.adelaide.on.net...
I tried this Ian and when I try to nominate the database that I want the
data link with, and then choose MS Acess Database (*.mdb; *.mde), I get an
error that says "Word cannot re-establish a DDE connection to Microsoft
Access to complete the current task." I have done an extensive internet
search on this and have not turned up anything helpful at this stage.

dixie

"Ian Hinson" <pp******@bigpond.net.au> wrote in message
news:pT******************@news-server.bigpond.net.au...
I reckon the best way forward to debug this is to see whether you can
create a mail merge against the MDE file "by hand" ie. from within Word
itself interactively, both with the MDE opened and with it not opened.
This will enable you to test your assumption of whether the opened MDE is
somehow locking you out of the data.
Once you can do it by hand, then you should be able to do the same thing
using automation.

Ian.

"Dixie" <di***@dogmail.com> wrote in message
news:43********@duster.adelaide.on.net...
I have a mailmerge that works fine from an MDB database using the
OpenDataSource method to send its data from a query within Access as part
of an automation sequence. Now, if I compile that mdb into an MDE, when
I click a button on the Access form that should produce the mailmerge,
the template opens on the screen with the fields visible, then an error
message.

"File in use. <Filename> is locked for editing by 'another user'."

I then have to shut the Word document down and when I return to the
Access App form, the Microsoft Access Error "Word is unable to open the
data source." is visible. I have previously run mailmerges by the
DoCmd.TransferText method and had the mail merge main document find the
small textfile produced with the data in it, but I want to use this
OpendDataSource method to send out the name of the query in Access where
the merge data is to be found.

The query works fine. What seems to be stopping it from working is that
it sees the MDE as being locked for editing by another user (but it is
OK if it is an MDB) There must be something I am missing here and I
can't believe it hasn't happened to others.

If you have run into this before could you please explain why this is
occurring?



Nov 13 '05 #4

P: n/a
http://support.microsoft.com/default...&Product=offxp

"Ian Hinson" <pp******@bigpond.net.au> wrote in message
news:MT******************@news-server.bigpond.net.au...
See if this can help:
http://support.microsoft.com/default...b;EN-US;291445

"Dixie" <di***@dogmail.com> wrote in message
news:43******@duster.adelaide.on.net...
I tried this Ian and when I try to nominate the database that I want the
data link with, and then choose MS Acess Database (*.mdb; *.mde), I get an
error that says "Word cannot re-establish a DDE connection to Microsoft
Access to complete the current task." I have done an extensive internet
search on this and have not turned up anything helpful at this stage.

dixie

"Ian Hinson" <pp******@bigpond.net.au> wrote in message
news:pT******************@news-server.bigpond.net.au...
I reckon the best way forward to debug this is to see whether you can
create a mail merge against the MDE file "by hand" ie. from within Word
itself interactively, both with the MDE opened and with it not opened.
This will enable you to test your assumption of whether the opened MDE
is somehow locking you out of the data.
Once you can do it by hand, then you should be able to do the same thing
using automation.

Ian.

"Dixie" <di***@dogmail.com> wrote in message
news:43********@duster.adelaide.on.net...
I have a mailmerge that works fine from an MDB database using the
OpenDataSource method to send its data from a query within Access as
part of an automation sequence. Now, if I compile that mdb into an MDE,
when I click a button on the Access form that should produce the
mailmerge, the template opens on the screen with the fields visible,
then an error message.

"File in use. <Filename> is locked for editing by 'another user'."

I then have to shut the Word document down and when I return to the
Access App form, the Microsoft Access Error "Word is unable to open the
data source." is visible. I have previously run mailmerges by the
DoCmd.TransferText method and had the mail merge main document find the
small textfile produced with the data in it, but I want to use this
OpendDataSource method to send out the name of the query in Access
where the merge data is to be found.

The query works fine. What seems to be stopping it from working is
that it sees the MDE as being locked for editing by another user (but
it is OK if it is an MDB) There must be something I am missing here
and I can't believe it hasn't happened to others.

If you have run into this before could you please explain why this is
occurring?



Nov 13 '05 #5

P: n/a
Found both of these in my research Ian. None of them seemed relevant to my
circumstances. I think I'll just go back to my original method of
mailmerge, but it is a pain.

Thanks for your help.
dixie

"Ian Hinson" <pp******@bigpond.net.au> wrote in message
news:GU******************@news-server.bigpond.net.au...
http://support.microsoft.com/default...&Product=offxp

"Ian Hinson" <pp******@bigpond.net.au> wrote in message
news:MT******************@news-server.bigpond.net.au...
See if this can help:
http://support.microsoft.com/default...b;EN-US;291445

"Dixie" <di***@dogmail.com> wrote in message
news:43******@duster.adelaide.on.net...
I tried this Ian and when I try to nominate the database that I want the
data link with, and then choose MS Acess Database (*.mdb; *.mde), I get
an error that says "Word cannot re-establish a DDE connection to
Microsoft Access to complete the current task." I have done an extensive
internet search on this and have not turned up anything helpful at this
stage.

dixie

"Ian Hinson" <pp******@bigpond.net.au> wrote in message
news:pT******************@news-server.bigpond.net.au...
I reckon the best way forward to debug this is to see whether you can
create a mail merge against the MDE file "by hand" ie. from within Word
itself interactively, both with the MDE opened and with it not opened.
This will enable you to test your assumption of whether the opened MDE
is somehow locking you out of the data.
Once you can do it by hand, then you should be able to do the same
thing using automation.

Ian.

"Dixie" <di***@dogmail.com> wrote in message
news:43********@duster.adelaide.on.net...
>I have a mailmerge that works fine from an MDB database using the
>OpenDataSource method to send its data from a query within Access as
>part of an automation sequence. Now, if I compile that mdb into an
>MDE, when I click a button on the Access form that should produce the
>mailmerge, the template opens on the screen with the fields visible,
>then an error message.
>
> "File in use. <Filename> is locked for editing by 'another user'."
>
> I then have to shut the Word document down and when I return to the
> Access App form, the Microsoft Access Error "Word is unable to open
> the data source." is visible. I have previously run mailmerges by the
> DoCmd.TransferText method and had the mail merge main document find
> the small textfile produced with the data in it, but I want to use
> this OpendDataSource method to send out the name of the query in
> Access where the merge data is to be found.
>
> The query works fine. What seems to be stopping it from working is
> that it sees the MDE as being locked for editing by another user (but
> it is OK if it is an MDB) There must be something I am missing here
> and I can't believe it hasn't happened to others.
>
> If you have run into this before could you please explain why this is
> occurring?
>
>



Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.