Re: Merging from Access database on server

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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" <SarahG@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:872BAE9C-9C3D-4A31-BFFD-21DF444417AC@xxxxxxxxxxxxxxxx
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.

.

Relevant Pages

  • Re: Remembering associated database
    ... Take the steps to eliminate the SQL warning and then save the mail merge ... main document after attaching the data source to it. ... Each time the document is opened, I have to reconnect the database to the ... But, when pressing "Yes" to allow the connection, I'm then ...
    (microsoft.public.word.mailmerge.fields)
  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • ANN: Sequel 3.11.0 Released
    ... Sequel is a lightweight database access toolkit for Ruby. ... Sequel provides thread safety, connection pooling and a concise DSL ... for constructing database queries and table schemas. ...
    (comp.lang.ruby)
  • ANN: Sequel 3.9.0 Released
    ... Sequel is a lightweight database access toolkit for Ruby. ... Sequel provides thread safety, connection pooling and a concise DSL ... the default connection pool no longer contains ...
    (comp.lang.ruby)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)