Merging from secured Access database

[Dean]

I have a secured Access database with most users only allowed to see
personnel records from within their group. I have a single user logon for
each group (6 total) and an initial query that restricts records from the
entire database to those with the group matching currentuser(). This works
well WITHIN Access, but when I try to link (using ODBC) a Word merge to it, I
can see the query name, but I get a Word message telling me that there are no
records.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?RGVhbg==?=,

I have a secured Access database with most users only allowed to see
personnel records from within their group. I have a single user logon for
each group (6 total) and an initial query that restricts records from the
entire database to those with the group matching currentuser(). This works
well WITHIN Access, but when I try to link (using ODBC) a Word merge to it, I
can see the query name, but I get a Word message telling me that there are no
records.

If you're seeing the query, then it may be a query of a type Word doesn't
support. Does it contain aggregate or VBA-functions, for example? Or does it
demand a parameter to execute?

Which version of Word are we dealing with?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail