Just in case you haven't discovered it yet, AIUI .accdb doesn't support
the whole workgroup security file approach. AFAIK MS expects you to move
to the security features provided by (say) a SQL Server backend if you
need an equivalent. But I'm not an Access expert and perhaps that's an
oversimplification.
Peter Jamieson
http://tips.pjmsn.me.uk
On 11/05/2010 21:13, MikeV wrote:
Today things work. The original 2003 Access database is using a Workgroup
security file. I think that was getting in the way. Things finally got to
the point where Access was prompting me for a username and password for any
database and no usename/password combination would work. I was locked out of
all my databases.
I deleted the System.mdw file and everything finally cleared up. I created
a new 2007 blank database and imported everything from the 2003 database. I
was then able to link the Word documents using the "DDE for .mdb files"
option and everything worked after that. Thanks for the replies guys.
"Doug Robbins - Word MVP" wrote:
See the links in the following message posted by fellow MVP (and Bill Gates
look alike) Alber Kallal:
Quote
Actually, use my merge sample. it don't give that warning, and you don't
have to change registiry stuff etc.
The sample I have can be found he
http://www.members.shaw.ca/AlbertKal.../msaccess.html
What is nice/interesting about my sample is that is specially designed to
enable ANY form with ONE LINE of code....
Thus, each time you build a new form, you can word merge enable it with
great ease.
Make sure you read the instructions from above, and you should eventually
get to the follwoing page
http://www.members.shaw.ca/AlbertKal...rge/page2.html
Note that the merge can also use a query, and thus you don't have to merge
just "one" record..
After the merge occurs, you get a plain document WITHOUT any merge fields,
and this allows the end user to save, edit, or even email the document
(since the merge fields are gone after the merge occurs).
Give the above a try€¦
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Unquote
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
wrote in message
...
By using DDE for a .mdb database, is this implying that Word 2007 cannot
communicate with an Access 2007 database via DDE?
When I try this with an Access 2007 database, it still does not work. The
query pulls
a value off a form to satisfy a criteria entry. When I run it, it prompts
for the value instead of pulling it off the form. This worked when both
the
Word document and the database were 2003, but in 2007, they don't work.
Do I
need to leave my Access database 2003?
"Peter Jamieson" wrote:
The only easy way to do it is to change the way that Word connects to
the data source to DDE
in Word 2007, check Office button-Word options-Advanced-Confirm file
format conversion on open (near the bottom), go through the connection
process again, and you should see an additional Confirm Data Source
dialog box. If you see an entry like "MS Access databases via DDE",
select it. If you only see "OLE DB database files" (typically if you are
using a .accdb rather than a .mdb source), check Show all, then locate
and select that DDE option, and continue. In Word 2003, the option has a
similar name under Tools-Options-General.
Peter Jamieson
http://tips.pjmsn.me.uk
On 21/02/2010 15:52, sailor wrote:
I am trying to create a Word mail merge with an Access database query
that
has a parameter (asks for a unique date).
When Word asks for "Select Recipients" I go to my database and the
dialog
box lists the database along with all of my Queries EXCEPT QUERIES THAT
HAVE
A PARAMETER so I cannot select the parameter query that contains the
list of
recipients that I want send to .
How do I get the parameter query to be listed so I can select it to be
the
target of my Mail Merge?
.