Home All Groups Group Topic Archive Search About

Unable to merge after sharing database

Author
11 Jul 2006 7:07 PM
James
What did I leave out?

Added security in access 2003 and lost the abbility to merge with word 2003!

Author
13 Jul 2006 1:23 PM
Joan Wild
Could you provide more details?

What error message are you getting?

Are you merging from within Access, or from Word?

What steps did you take?


--
Joan Wild
Microsoft Access MVP

James wrote:
Show quoteHide quote
> What did I leave out?
>
> Added security in access 2003 and lost the abbility to merge with
> word 2003!
Author
14 Jul 2006 7:31 PM
James
Please read the info next to your questions

James

Show quoteHide quote
"Joan Wild" wrote:

> Could you provide more details?
>
> What error message are you getting? Word was unable to open data source
>
> Are you merging from within Access, or from Word? word
>
> What steps did you take? Tryed to Querie the acces data file as we have in the past. also we are using access security
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> James wrote:
> > What did I leave out?
> >
> > Added security in access 2003 and lost the abbility to merge with
> > word 2003!
>
>
>
Author
16 Jul 2006 3:14 PM
Joan Wild
If you want to do it from within Word, you'll need to be joined by default
to your secure workgroup file.

I would also suggest you open Word, Tools, Options, General tab and ensure
that 'Confirm conversion on open' is checked.

Start the merge, and when you select the data source, choose your secure mdb
file.  In the 'Confirm Data Source' dialog choose 'via DDE' and you'll be
prompted for the Access username/password to open the data source.

This is the only way I've found to succeed from within Word.

You could, instead, do the merge from within Access.  Since you would have
already signed in to the Access database, you're already authenticated for
the Access security.  Use Tools, Office Links, Merge it with Word and
proceed from there.


--
Joan Wild
Microsoft Access MVP

James wrote:
Show quoteHide quote
> Please read the info next to your questions
>
> James
>
> "Joan Wild" wrote:
>
>> Could you provide more details?
>>
>> What error message are you getting? Word was unable to open data
>> source
>>
>> Are you merging from within Access, or from Word? word
>>
>> What steps did you take? Tryed to Querie the acces data file as we
>> have in the past. also we are using access security
>>
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>>
>> James wrote:
>>> What did I leave out?
>>>
>>> Added security in access 2003 and lost the abbility to merge with
>>> word 2003!