G
Guest
Not sure where to post this question.
I have a split, secured database at work and have found it necessary to mail
merge a query into Word. After selecting my query in the Access database
window, I get a dialog box asking if I want to use an existing document or
create a new one. I choose create new. Word opens with a new doc and I get a
'select table' dialog with a list of tables from the database file. There is
also an options button here that allows me to select tables, views, system
tables or synonyms (?). I select views and it shows my queries from the db,
but when I select one, Access becomes the active window with the error "Word
cannot open the data source".
I've also tried it by starting from within Word with a new document, using
the mail merge wizard, same error message.
I believe its probably that the DB is secured, but don't know how to get
around it. I am the DB admin with full admin permissions.
Can anyone help?
Ripper
I have a split, secured database at work and have found it necessary to mail
merge a query into Word. After selecting my query in the Access database
window, I get a dialog box asking if I want to use an existing document or
create a new one. I choose create new. Word opens with a new doc and I get a
'select table' dialog with a list of tables from the database file. There is
also an options button here that allows me to select tables, views, system
tables or synonyms (?). I select views and it shows my queries from the db,
but when I select one, Access becomes the active window with the error "Word
cannot open the data source".
I've also tried it by starting from within Word with a new document, using
the mail merge wizard, same error message.
I believe its probably that the DB is secured, but don't know how to get
around it. I am the DB admin with full admin permissions.
Can anyone help?
Ripper