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

P

Piet

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
 
J

Joan Wild

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top