links from Word to Access mdb lost after defining user accounts?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Piet - 29 Jan 2007 16:59 GMT

Hi,
I have a problem that Word documents referring to an MS Access mdb for merging cannot find the mdb anymore. Even redefining the mdb
link from Word does not work. Word says that the mdb was not found on the network location, where it definitely is.
Could it be that this was caused by defining user accounts in Access, which makes that system.mdw (the workgroup file) was changed?

Or could it be caused by changing the Access mdb - I think the original mdb was deleted and a new one was given the original mdb's
name.
N.B.: The field names did not change.

Thanks so much for advice,
Piet

Reply to this Message

Joan Wild - 29 Jan 2007 18:54 GMT

It is likely that implementing security has caused the problem. If you
want to do the merge from within Word, you'll need to make your secure
workgroup file the default.

I have always had better success starting the Word merge from within the
secure Access session. 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.

Signature

Joan Wild
Microsoft Access MVP

> Hi,
> I have a problem that Word documents referring to an MS Access mdb for
[quoted text clipped - 11 lines]
> Thanks so much for advice,
> Piet

Reply to this Message