Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Sarah G Sarah G is offline
external usenet poster
 
Posts: 6
Default Merging from Access database on server

I have created several Word merge documents to be used with an Access
database. The database and merge documents are located on a server that
multiple users can access. However, when other users try to use the merge
documents, they get warnings that the data source connection has been lost,
and they have to go through a series of steps to reset the database
connection. The files are all located in the same folder as the database and
have not been changed, moved, or renamed. I do not see these warning
messages and can use the files just as I created them. I would like to make
it so that they don't have to go through these extra steps every time they
open a merge document.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Merging from Access database on server

Which version of Word? What type of connection are you using (DDE, ODBC, OLE
DB)?

Are they seeing the SQL warning dialog (typically you need to change a
registry entry on each user's machine to make this go away)? Are they also
seeing other error messages?

Are all the users using the same path to access the documents, or are some
of them using (say) a network path mapped to a drive letter?

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Sarah G" wrote in message
...
I have created several Word merge documents to be used with an Access
database. The database and merge documents are located on a server that
multiple users can access. However, when other users try to use the merge
documents, they get warnings that the data source connection has been
lost,
and they have to go through a series of steps to reset the database
connection. The files are all located in the same folder as the database
and
have not been changed, moved, or renamed. I do not see these warning
messages and can use the files just as I created them. I would like to
make
it so that they don't have to go through these extra steps every time they
open a merge document.


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merging an Access Database to a Table Marilyn Mailmerge 3 August 18th 06 04:46 AM
MailMerge cannot access Exchange Server error R Mailmerge 1 July 27th 06 08:32 PM
Merging/database management Anthony J. B. Mailmerge 8 June 1st 06 07:00 PM
Merging Works Database file John B Mailmerge 1 January 17th 06 02:33 PM
Merging from secured Access database Dean Mailmerge 1 December 4th 05 11:54 AM


All times are GMT +1. The time now is 05:26 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"