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

.mde won't merge!!

P: n/a
I've had to make .mde files out of my front ends because of security
problems. Now I find that my MS Word merge letters won't work. First
thing I did was try to reset the connect to contracts.mde instead of the
original contracts.mdb. Tried this on two diff databases.

First I get the .mde file is locked for editing and when I click on
okay, I get a pop up titled "Header Record Delimiters which gives a
preview of garbage which includes the words "standard jet" which surely
is the header info for the access database.

I have code behind a button on a form that calls Word to load the merge
contract which connects to a 'Printing' table in the database. Do I
have to set up a dummy .mdb with a printing table in it? If so, how
would I print to an external table from VBA on a form?

Sure hope I can get help fast as I'm being hit from both ends - mgt
wanting it secured and users wanting to be able to print contracts!

thanks,
judy
Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Judy Picard wrote:
I've had to make .mde files out of my front ends because of security
problems. Now I find that my MS Word merge letters won't work. First
thing I did was try to reset the connect to contracts.mde instead of the
original contracts.mdb. Tried this on two diff databases.

First I get the .mde file is locked for editing and when I click on
okay, I get a pop up titled "Header Record Delimiters which gives a
preview of garbage which includes the words "standard jet" which surely
is the header info for the access database.

I have code behind a button on a form that calls Word to load the merge
contract which connects to a 'Printing' table in the database. Do I
have to set up a dummy .mdb with a printing table in it? If so, how
would I print to an external table from VBA on a form?

Sure hope I can get help fast as I'm being hit from both ends - mgt
wanting it secured and users wanting to be able to print contracts!

thanks,
judy


If you have your application split into front end/back end then link to
the back end.

I've always noticed problems using merges and the like this way, locking
issues, general breakdown of windows's DDE, etc so I never use it.
Instead I just output a CSV file or something and use that for Word to
work on, the oldest technology out there for this sort of thing and 100%
reliable and will still work the same in a new version of Access and
doesn't require that Word & Access are of the same version Office suite.
--
Pretentious? Moi?
Nov 13 '05 #2

P: n/a
<SNIP>
I've always noticed problems using merges and the like this way, locking
issues, general breakdown of windows's DDE, etc so I never use it.
Instead I just output a CSV file or something and use that for Word to
work on, the oldest technology out there for this sort of thing and 100%
reliable and will still work the same in a new version of Access and
doesn't require that Word & Access are of the same version Office suite.


</SNIP>
<putting on my Albert Kallal costume>
To follow up on what Trevor said, you can download some code that does
most, if not all of this stuff for you from Albert Kallal's webpage.
(wait, that would be "my" then, right?) right here...

http://www.attcanada.net/~kallal.msn.../msaccess.html

Then look for "Super Easy Word Merge". read, download, follow
instructions. Nothing to it.
Nov 13 '05 #3

P: n/a
Judy Picard wrote:
I've had to make .mde files out of my front ends because of security
problems. Now I find that my MS Word merge letters won't work. First
thing I did was try to reset the connect to contracts.mde instead of
the original contracts.mdb. Tried this on two diff databases.

First I get the .mde file is locked for editing and when I click on
okay, I get a pop up titled "Header Record Delimiters which gives a
preview of garbage which includes the words "standard jet" which
surely is the header info for the access database.


Rename the mde file to have a mdb extension.
http://support.microsoft.com/default...b;en-us;180663
--
Joan Wild
Microsoft Access MVP

Nov 13 '05 #4

P: n/a
Pieter Linden wrote:
<putting on my Albert Kallal costume>


Is that like, a cape and a mask? ;-)

--
Pretentious? Moi?
Nov 13 '05 #5

P: n/a
Yes!!! That was the solution. beats all others by eons of miles! thanks!
judy

Joan Wild wrote:
Judy Picard wrote:
I've had to make .mde files out of my front ends because of security
problems. Now I find that my MS Word merge letters won't work. First
thing I did was try to reset the connect to contracts.mde instead of
the original contracts.mdb. Tried this on two diff databases.

First I get the .mde file is locked for editing and when I click on
okay, I get a pop up titled "Header Record Delimiters which gives a
preview of garbage which includes the words "standard jet" which
surely is the header info for the access database.

Rename the mde file to have a mdb extension.
http://support.microsoft.com/default...b;en-us;180663

Nov 13 '05 #6

P: n/a
Trevor Best <nospam@localhost> wrote in message news:<41***********************@auth.uk.news.easyn et.net>...
Pieter Linden wrote:
<putting on my Albert Kallal costume>


Is that like, a cape and a mask? ;-)


Not sure, Trevor. You might need to ask the *real* Albert K about that one...

Sure wish *I* could fly like Superman...
Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.