Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Updating Linked Tables

Discussion in 'Information Technology' started by acbc66, Oct 27, 2005.

  1. acbc66

    acbc66
    Expand Collapse
    Guest

    I have several Excel spreadsheets as linked tables in Access, and I can't
    update the data in these tables. I don't have any relationships among the
    tables, so I know it's not a problem with referential integrity. I recently
    changed the paths to the tables using Linked Table Manager, and the problem
    seems to have arisen after that, but none of the paths/directories are
    protected, so I'm stumped.
     
  2. Loading...

    Similar Threads Forum Date
    Opinion Letter: When terrorism is falsely linked by race or religion, we all become the victims Breaking News Apr 27, 2013
    SciTech Law of Entropy Linked to Evolution of Intelligence Breaking News Apr 23, 2013
    Canada GM corn linked to early death in new study Breaking News Sep 22, 2012
    India set to ban 100 Al Qaeda-linked groups Hard Talk May 17, 2010
    Sikh News Temple linked to terrorists still active (Moldova.org) Breaking News Feb 5, 2008

  3. Ken Snell [MVP]

    Ken Snell [MVP]
    Expand Collapse
    Guest

    Are you using ACCESS 2003? Did you just update it to SP2? Unfortunately,
    updating linked EXCEL files no longer is allowed in ACCESS 2003 SP2.

    See this Knowledge Base article:
    http://support.microsoft.com/kb/904953/en-us

    --

    Ken Snell
    <MS ACCESS MVP>


    "acbc66" <acbc66@discussions.microsoft.com> wrote in message
    news:05BE8C8D-7982-4B12-8EDD-D2AB76AB2BFE@microsoft.com...
    >I have several Excel spreadsheets as linked tables in Access, and I can't
    > update the data in these tables. I don't have any relationships among the
    > tables, so I know it's not a problem with referential integrity. I
    > recently
    > changed the paths to the tables using Linked Table Manager, and the
    > problem
    > seems to have arisen after that, but none of the paths/directories are
    > protected, so I'm stumped.
     
  4. acbc66

    acbc66
    Expand Collapse
    Guest

    Nope, Access 2002...

    "acbc66" wrote:

    > I have several Excel spreadsheets as linked tables in Access, and I can't
    > update the data in these tables. I don't have any relationships among the
    > tables, so I know it's not a problem with referential integrity. I recently
    > changed the paths to the tables using Linked Table Manager, and the problem
    > seems to have arisen after that, but none of the paths/directories are
    > protected, so I'm stumped.
     
  5. acbc66

    acbc66
    Expand Collapse
    Guest

    OK, Ken, thanks. I just read the article and I guess I must have installed
    SP2 (probably automatic update). I guess I'm SOL, since the database has
    several features which query the Linked spreadsheets so they could (used to)
    be updated. I suppose I could try reinstalling Office 2002, sans Service Pak
    2.



    "Ken Snell [MVP]" wrote:

    > Are you using ACCESS 2003? Did you just update it to SP2? Unfortunately,
    > updating linked EXCEL files no longer is allowed in ACCESS 2003 SP2.
    >
    > See this Knowledge Base article:
    > http://support.microsoft.com/kb/904953/en-us
    >
    > --
    >
    > Ken Snell
    > <MS ACCESS MVP>
    >
    >
    > "acbc66" <acbc66@discussions.microsoft.com> wrote in message
    > news:05BE8C8D-7982-4B12-8EDD-D2AB76AB2BFE@microsoft.com...
    > >I have several Excel spreadsheets as linked tables in Access, and I can't
    > > update the data in these tables. I don't have any relationships among the
    > > tables, so I know it's not a problem with referential integrity. I
    > > recently
    > > changed the paths to the tables using Linked Table Manager, and the
    > > problem
    > > seems to have arisen after that, but none of the paths/directories are
    > > protected, so I'm stumped.

    >
    >
    >
     
  6. Ken Snell [MVP]

    Ken Snell [MVP]
    Expand Collapse
    Guest

    I'm using Office XP SP3 and can still update linked EXCEL files. Not sure
    yet which update to Office XP turns this feature off, but I'm going to be
    very wary of what I install for the time being....

    --

    Ken Snell
    <MS ACCESS MVP>



    "acbc66" <acbc66@discussions.microsoft.com> wrote in message
    news:C4B44658-AD65-4E57-97E3-2562541FC64D@microsoft.com...
    > OK, Ken, thanks. I just read the article and I guess I must have
    > installed
    > SP2 (probably automatic update). I guess I'm SOL, since the database has
    > several features which query the Linked spreadsheets so they could (used
    > to)
    > be updated. I suppose I could try reinstalling Office 2002, sans Service
    > Pak
    > 2.
    >
    >
    >
    > "Ken Snell [MVP]" wrote:
    >
    >> Are you using ACCESS 2003? Did you just update it to SP2? Unfortunately,
    >> updating linked EXCEL files no longer is allowed in ACCESS 2003 SP2.
    >>
    >> See this Knowledge Base article:
    >> http://support.microsoft.com/kb/904953/en-us
    >>
    >> --
    >>
    >> Ken Snell
    >> <MS ACCESS MVP>
    >>
    >>
    >> "acbc66" <acbc66@discussions.microsoft.com> wrote in message
    >> news:05BE8C8D-7982-4B12-8EDD-D2AB76AB2BFE@microsoft.com...
    >> >I have several Excel spreadsheets as linked tables in Access, and I
    >> >can't
    >> > update the data in these tables. I don't have any relationships among
    >> > the
    >> > tables, so I know it's not a problem with referential integrity. I
    >> > recently
    >> > changed the paths to the tables using Linked Table Manager, and the
    >> > problem
    >> > seems to have arisen after that, but none of the paths/directories are
    >> > protected, so I'm stumped.

    >>
    >>
    >>
     
  7. acbc66

    acbc66
    Expand Collapse
    Guest

    I did a little more sleuthing, and found that it's update KB904018, dated Oct
    18, 2005. See http://support.microsoft.com/kb/904018

    It must have installed via automatic updates to my system, as I sure didn't
    want this, um 'feature'. Be afraid...be very afraid.

    "Ken Snell [MVP]" wrote:

    > I'm using Office XP SP3 and can still update linked EXCEL files. Not sure
    > yet which update to Office XP turns this feature off, but I'm going to be
    > very wary of what I install for the time being....
    >
    > --
    >
    > Ken Snell
    > <MS ACCESS MVP>
    >
    >
    >
    > "acbc66" <acbc66@discussions.microsoft.com> wrote in message
    > news:C4B44658-AD65-4E57-97E3-2562541FC64D@microsoft.com...
    > > OK, Ken, thanks. I just read the article and I guess I must have
    > > installed
    > > SP2 (probably automatic update). I guess I'm SOL, since the database has
    > > several features which query the Linked spreadsheets so they could (used
    > > to)
    > > be updated. I suppose I could try reinstalling Office 2002, sans Service
    > > Pak
    > > 2.
    > >
    > >
    > >
    > > "Ken Snell [MVP]" wrote:
    > >
    > >> Are you using ACCESS 2003? Did you just update it to SP2? Unfortunately,
    > >> updating linked EXCEL files no longer is allowed in ACCESS 2003 SP2.
    > >>
    > >> See this Knowledge Base article:
    > >> http://support.microsoft.com/kb/904953/en-us
    > >>
    > >> --
    > >>
    > >> Ken Snell
    > >> <MS ACCESS MVP>
    > >>
    > >>
    > >> "acbc66" <acbc66@discussions.microsoft.com> wrote in message
    > >> news:05BE8C8D-7982-4B12-8EDD-D2AB76AB2BFE@microsoft.com...
    > >> >I have several Excel spreadsheets as linked tables in Access, and I
    > >> >can't
    > >> > update the data in these tables. I don't have any relationships among
    > >> > the
    > >> > tables, so I know it's not a problem with referential integrity. I
    > >> > recently
    > >> > changed the paths to the tables using Linked Table Manager, and the
    > >> > problem
    > >> > seems to have arisen after that, but none of the paths/directories are
    > >> > protected, so I'm stumped.
    > >>
    > >>
    > >>

    >
    >
    >
     
  8. Ken Snell [MVP]

    Ken Snell [MVP]
    Expand Collapse
    Guest

    Thanks for this info.

    --

    Ken Snell
    <MS ACCESS MVP>

    "Ken Snell [MVP]" <kthsneisllis9@ncoomcastt.renaetl> wrote in message
    news:eZ1ql2p2FHA.3788@tk2msftngp13.phx.gbl...
    > I'm using Office XP SP3 and can still update linked EXCEL files. Not sure
    > yet which update to Office XP turns this feature off, but I'm going to be
    > very wary of what I install for the time being....
    >
    > --
    >
    > Ken Snell
    > <MS ACCESS MVP>
    >
    >
    >
    > "acbc66" <acbc66@discussions.microsoft.com> wrote in message
    > news:C4B44658-AD65-4E57-97E3-2562541FC64D@microsoft.com...
    >> OK, Ken, thanks. I just read the article and I guess I must have
    >> installed
    >> SP2 (probably automatic update). I guess I'm SOL, since the database has
    >> several features which query the Linked spreadsheets so they could (used
    >> to)
    >> be updated. I suppose I could try reinstalling Office 2002, sans Service
    >> Pak
    >> 2.
    >>
    >>
    >>
    >> "Ken Snell [MVP]" wrote:
    >>
    >>> Are you using ACCESS 2003? Did you just update it to SP2? Unfortunately,
    >>> updating linked EXCEL files no longer is allowed in ACCESS 2003 SP2.
    >>>
    >>> See this Knowledge Base article:
    >>> http://support.microsoft.com/kb/904953/en-us
    >>>
    >>> --
    >>>
    >>> Ken Snell
    >>> <MS ACCESS MVP>
    >>>
    >>>
    >>> "acbc66" <acbc66@discussions.microsoft.com> wrote in message
    >>> news:05BE8C8D-7982-4B12-8EDD-D2AB76AB2BFE@microsoft.com...
    >>> >I have several Excel spreadsheets as linked tables in Access, and I
    >>> >can't
    >>> > update the data in these tables. I don't have any relationships among
    >>> > the
    >>> > tables, so I know it's not a problem with referential integrity. I
    >>> > recently
    >>> > changed the paths to the tables using Linked Table Manager, and the
    >>> > problem
    >>> > seems to have arisen after that, but none of the paths/directories are
    >>> > protected, so I'm stumped.
    >>>
    >>>
    >>>

    >
    >
     
  9. Ken Snell [MVP]

    Ken Snell [MVP]
    Expand Collapse
    Guest

    Thanks for this info.

    --

    Ken Snell
    <MS ACCESS MVP>

    "acbc66" <acbc66@discussions.microsoft.com> wrote in message
    news:AA173B4A-E78D-429C-AF22-8D7C1C8B7246@microsoft.com...
    >I did a little more sleuthing, and found that it's update KB904018, dated
    >Oct
    > 18, 2005. See http://support.microsoft.com/kb/904018
    >
    > It must have installed via automatic updates to my system, as I sure
    > didn't
    > want this, um 'feature'. Be afraid...be very afraid.
    >
    > "Ken Snell [MVP]" wrote:
    >
    >> I'm using Office XP SP3 and can still update linked EXCEL files. Not sure
    >> yet which update to Office XP turns this feature off, but I'm going to be
    >> very wary of what I install for the time being....
    >>
    >> --
    >>
    >> Ken Snell
    >> <MS ACCESS MVP>
    >>
    >>
    >>
    >> "acbc66" <acbc66@discussions.microsoft.com> wrote in message
    >> news:C4B44658-AD65-4E57-97E3-2562541FC64D@microsoft.com...
    >> > OK, Ken, thanks. I just read the article and I guess I must have
    >> > installed
    >> > SP2 (probably automatic update). I guess I'm SOL, since the database
    >> > has
    >> > several features which query the Linked spreadsheets so they could
    >> > (used
    >> > to)
    >> > be updated. I suppose I could try reinstalling Office 2002, sans
    >> > Service
    >> > Pak
    >> > 2.
    >> >
    >> >
    >> >
    >> > "Ken Snell [MVP]" wrote:
    >> >
    >> >> Are you using ACCESS 2003? Did you just update it to SP2?
    >> >> Unfortunately,
    >> >> updating linked EXCEL files no longer is allowed in ACCESS 2003 SP2.
    >> >>
    >> >> See this Knowledge Base article:
    >> >> http://support.microsoft.com/kb/904953/en-us
    >> >>
    >> >> --
    >> >>
    >> >> Ken Snell
    >> >> <MS ACCESS MVP>
    >> >>
    >> >>
    >> >> "acbc66" <acbc66@discussions.microsoft.com> wrote in message
    >> >> news:05BE8C8D-7982-4B12-8EDD-D2AB76AB2BFE@microsoft.com...
    >> >> >I have several Excel spreadsheets as linked tables in Access, and I
    >> >> >can't
    >> >> > update the data in these tables. I don't have any relationships
    >> >> > among
    >> >> > the
    >> >> > tables, so I know it's not a problem with referential integrity. I
    >> >> > recently
    >> >> > changed the paths to the tables using Linked Table Manager, and the
    >> >> > problem
    >> >> > seems to have arisen after that, but none of the paths/directories
    >> >> > are
    >> >> > protected, so I'm stumped.
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>
     
  10. John

    John
    Expand Collapse
    Guest

    Would someone be so kind as to explain why this was taken away?

    All I see is "For legal reasons". What is the "Legal reason"?

    Do we really think that someone told them to "REMOVE IT"? I don't think so.
    I think it's a bunch of crap and just an excuse.

    What the hell is MS doing or do they know what their doing?

    IMHO

    "Ken Snell [MVP]" wrote:

    > Are you using ACCESS 2003? Did you just update it to SP2? Unfortunately,
    > updating linked EXCEL files no longer is allowed in ACCESS 2003 SP2.
    >
    > See this Knowledge Base article:
    > http://support.microsoft.com/kb/904953/en-us
    >
    > --
    >
    > Ken Snell
    > <MS ACCESS MVP>
    >
    >
    > "acbc66" <acbc66@discussions.microsoft.com> wrote in message
    > news:05BE8C8D-7982-4B12-8EDD-D2AB76AB2BFE@microsoft.com...
    > >I have several Excel spreadsheets as linked tables in Access, and I can't
    > > update the data in these tables. I don't have any relationships among the
    > > tables, so I know it's not a problem with referential integrity. I
    > > recently
    > > changed the paths to the tables using Linked Table Manager, and the
    > > problem
    > > seems to have arisen after that, but none of the paths/directories are
    > > protected, so I'm stumped.

    >
    >
    >
     
  11. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    "John" <John@discussions.microsoft.com> wrote:

    >Would someone be so kind as to explain why this was taken away?
    >
    >All I see is "For legal reasons". What is the "Legal reason"?
    >
    >Do we really think that someone told them to "REMOVE IT"? I don't think so.
    >I think it's a bunch of crap and just an excuse.
    >
    >What the hell is MS doing or do they know what their doing?


    It appears to be the following.
    Patent ruling costs Microsoft $8.9 million
    http://news.com.com/Patent+ruling+costs+Microsoft+8.9+million/2100-1007_3-5735432.html

    All the more reason to disallow software patents. They are getting
    quite ridiculous.

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     
  12. acbc66

    acbc66
    Expand Collapse
    Guest

    "Tony Toews" wrote:

    > "John" <John@discussions.microsoft.com> wrote:
    >
    > >Would someone be so kind as to explain why this was taken away?
    > >
    > >All I see is "For legal reasons". What is the "Legal reason"?
    > >
    > >Do we really think that someone told them to "REMOVE IT"? I don't think so.
    > >I think it's a bunch of crap and just an excuse.
    > >
    > >What the hell is MS doing or do they know what their doing?

    >
    > It appears to be the following.
    > Patent ruling costs Microsoft $8.9 million
    > http://news.com.com/Patent+ruling+costs+Microsoft+8.9+million/2100-1007_3-5735432.html
    >
    > All the more reason to disallow software patents. They are getting
    > quite ridiculous.
    >
    > Tony
    > --
    > Tony Toews, Microsoft Access MVP
    > Please respond only in the newsgroups so that others can
    > read the entire thread of messages.
    > Microsoft Access Links, Hints, Tips & Accounting Systems at
    > http://www.granite.ab.ca/accsmstr.htm
    >


    Thanks, Tony...I love the quote from the article: "We do not believe
    today's verdict will have any impact on our customers," said Microsoft
    spokeswoman Stacy Drake. Anybody got a dish of crow I can send to Ms.
    Drake??? sheesh.
     

Share This Page