Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging from secured Access database
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging from secured Access database
Hi ?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 :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to establish a dde link with an access database | Mailmerge | |||
How to insert only selected fields from Access database in Word? | Microsoft Word Help | |||
Mail Merge to a secured Access database | Mailmerge | |||
Using Secured Access Database as Datasource | Mailmerge | |||
Using as secured Access database as the data source for a mail mer | Mailmerge |