mde with mailmerge

[a0000]

I have created a small system which is used<br>
do to a lot of mail merging i.e. access to word.<br>
<br>
It works perfectly, but when I make the database an mde file it won't work at all.<br>
<br>
Word will not recognise the data fields from<br>
the database in mde form<br>
<br>
any ideas - thanks.

 

[DougP]

Is Word merging to a query or just a table.<br>
If its just a table<br>
Try making the (those) tables a Linked table.<br>
Access has a wizard for doing this which makes a Back end of all tables and creates a second .MDB caleeed Mytable-BE.mdb<br>
This of course is a good Idea when working with .MDE's too. Becasue as you know the data is not reatained in the .MDB when it is compiled into a .MDE anyway.<br>
Or if you have been using a .MDE the data is more upto date thant the last time you compiled from a .MDB.<br>
<br>
Hope this Helps <p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>