Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / December 2007

Tip: Looking for answers? Try searching our database.

Data Source seems frozen

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Claudette Hennessy - 05 Dec 2007 13:49 GMT
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?
Peter Jamieson - 05 Dec 2007 18:12 GMT
> 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.

Signature

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

>A system is running Office 2003 SP2
> Last Friday I set odc data sources for documents for a new database.  Some
[quoted text clipped - 13 lines]
>
> Does anyone have any ideas about likely culprits?
Claudette Hennessy - 07 Dec 2007 17:08 GMT
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

>> Does anyone have any ideas about likely culprits?
>
[quoted text clipped - 23 lines]
>>
>> Does anyone have any ideas about likely culprits?
Peter Jamieson - 08 Dec 2007 09:10 GMT
Interesting that /they/ couldn't work it out!

Signature

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

> Thank you for your reponse, Peter.
> The links show up as odc extensions in the My Data Sources folder, don't
[quoted text clipped - 37 lines]
>>>
>>> Does anyone have any ideas about likely culprits?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.