Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Claudette Hennessy Claudette Hennessy is offline
external usenet poster
 
Posts: 2
Default Data Source seems frozen

A system is running Office 2003 SP2
Last Friday I set odc data sources for documents for a new database. Some
of the sources are queries, and some are tables. Since then the users
attempted to create odc data sources for other documents after adding more
records and another (new) table. In Access, both the queries and the tables
reflect the additional data.

In Word, the data source choice wizard does not display the new table as a
choice, and the documents linked to the old table do not reflect the new
data. The documents already linked to the queries reflect the new data, but
a new query added to the database does not show up in the data source
choices.

I cannot duplicate this problem in my system, also running Office 2003 SP2.

Does anyone have any ideas about likely culprits?



  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Data Source seems frozen

Does anyone have any ideas about likely culprits?

Are you using .odc s because you also have a workgroup security database?

If so, do the users know how to set up a .odc that references the security
database? If not, they will be logged in as Admin and will only see the
tables that Admin has permissions for. Or something like that. Not sure why
they would not see new /data/, but that's probably where I would start
looking based on the info. available.

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

"Claudette Hennessy" wrote in message
...
A system is running Office 2003 SP2
Last Friday I set odc data sources for documents for a new database. Some
of the sources are queries, and some are tables. Since then the users
attempted to create odc data sources for other documents after adding more
records and another (new) table. In Access, both the queries and the
tables reflect the additional data.

In Word, the data source choice wizard does not display the new table as a
choice, and the documents linked to the old table do not reflect the new
data. The documents already linked to the queries reflect the new data,
but a new query added to the database does not show up in the data source
choices.

I cannot duplicate this problem in my system, also running Office 2003
SP2.

Does anyone have any ideas about likely culprits?




  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Claudette Hennessy Claudette Hennessy is offline
external usenet poster
 
Posts: 2
Default Data Source seems frozen

Thank you for your reponse, Peter.
The links show up as odc extensions in the My Data Sources folder, don't
have a security database, just linking to an access database. However.
It turns out that my users called up and sheepishly admitted that they had
copied the database to new location and were working from there; the links,
of course, were pointed to the old location. Am somewhat embarrassed to
post this, except that it provides an answer for a problem. The users did
not think to tell me of their actions, not realizing cause and effect, and I
did not think to ask them, since it is akin to reporting that the light does
not turn on after you have pulled the plug out of the wall. Sothe moral for
me is, if users report a problem with mail merge, the first question is did
you move the database.
Claudette

"Peter Jamieson" wrote in message
...
Does anyone have any ideas about likely culprits?


Are you using .odc s because you also have a workgroup security database?

If so, do the users know how to set up a .odc that references the security
database? If not, they will be logged in as Admin and will only see the
tables that Admin has permissions for. Or something like that. Not sure
why they would not see new /data/, but that's probably where I would start
looking based on the info. available.

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

"Claudette Hennessy" wrote in message
...
A system is running Office 2003 SP2
Last Friday I set odc data sources for documents for a new database.
Some of the sources are queries, and some are tables. Since then the
users attempted to create odc data sources for other documents after
adding more records and another (new) table. In Access, both the queries
and the tables reflect the additional data.

In Word, the data source choice wizard does not display the new table as
a choice, and the documents linked to the old table do not reflect the
new data. The documents already linked to the queries reflect the new
data, but a new query added to the database does not show up in the data
source choices.

I cannot duplicate this problem in my system, also running Office 2003
SP2.

Does anyone have any ideas about likely culprits?






  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Data Source seems frozen

Interesting that /they/ couldn't work it out!

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

"Claudette Hennessy" wrote in message
...
Thank you for your reponse, Peter.
The links show up as odc extensions in the My Data Sources folder, don't
have a security database, just linking to an access database. However.
It turns out that my users called up and sheepishly admitted that they had
copied the database to new location and were working from there; the
links, of course, were pointed to the old location. Am somewhat
embarrassed to post this, except that it provides an answer for a problem.
The users did not think to tell me of their actions, not realizing cause
and effect, and I did not think to ask them, since it is akin to reporting
that the light does not turn on after you have pulled the plug out of the
wall. Sothe moral for me is, if users report a problem with mail merge,
the first question is did you move the database.
Claudette

"Peter Jamieson" wrote in message
...
Does anyone have any ideas about likely culprits?


Are you using .odc s because you also have a workgroup security database?

If so, do the users know how to set up a .odc that references the
security database? If not, they will be logged in as Admin and will only
see the tables that Admin has permissions for. Or something like that.
Not sure why they would not see new /data/, but that's probably where I
would start looking based on the info. available.

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

"Claudette Hennessy" wrote in message
...
A system is running Office 2003 SP2
Last Friday I set odc data sources for documents for a new database.
Some of the sources are queries, and some are tables. Since then the
users attempted to create odc data sources for other documents after
adding more records and another (new) table. In Access, both the
queries and the tables reflect the additional data.

In Word, the data source choice wizard does not display the new table as
a choice, and the documents linked to the old table do not reflect the
new data. The documents already linked to the queries reflect the new
data, but a new query added to the database does not show up in the data
source choices.

I cannot duplicate this problem in my system, also running Office 2003
SP2.

Does anyone have any ideas about likely culprits?







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
How to link a different Mailmerge header source and data source? Eleni_Malli Mailmerge 1 May 3rd 06 02:08 PM
data form button greyed out in word 97 data source Busylady Mailmerge 0 September 15th 05 10:00 PM
DotNet Data Table as Mail Merge Data Source goraya Mailmerge 1 July 7th 05 09:51 AM
data in mail merge letter being cut off - data source field size? tgone Mailmerge 1 May 20th 05 02:10 PM
Merged data that is present in data source is missing in merge mbd_newjersey Mailmerge 1 December 17th 04 10:52 AM


All times are GMT +1. The time now is 02:48 AM.

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

About Us

"It's about Microsoft Word"