Publisher - Access data link issue

[Jeff Byrd]

I am not sure if this post belongs in this newsgroup or in Access. I have
not recieved an anser in the Access group so I will try it here.

I have a document designed in Publisher 2003 that I want to do a merge with
a query in Access 2003. When I choose the Access front end on the local
computer to link to and test the connection I get a "Microsoft Data Link
Error" window that states "Test onection failed because of an error
initializing provider. Cannot start you application. The workgroup
information file is missing or opened exclusively by another user."

The Access front end opens fine and the workgroup is joined properly. I
have tried adding the /wkgrp switch to the command line. The publisher
document will link fine with a separate dbf file.

We have Word documents that merge fine with this same Access Front end.

Any Thoughts?

 

[Mary Sauer]

Don't know if this will help. I assume it is also pertains to Publisher 2003

You receive a "Microsoft Data Link Error" error message when you try to perform
mail merge from read-only data source in Publisher 2002
http://support.microsoft.com/kb/279364/en-us

 

[jeff]

It sure looks like it should have had the answer, but it di not work. I
think it has something to do with the fact the Access database is secure.
Some dyas I sure wish Microsoft would make its products work together
better.

Don't know if this will help. I assume it is also pertains to Publisher
2003

You receive a "Microsoft Data Link Error" error message when you try to
perform mail merge from read-only data source in Publisher 2002
http://support.microsoft.com/kb/279364/en-us