Editing a linked table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access database that has worked beautiful for some time, however,
all the sudden has disabled my ability to add/edit records to a linked table
(table is linked to an .xls file). What would have made this change, and how
do I change it back to allow edits/additions to this linked table.
 
Hi, Lance.
What would have made this change, and how
do I change it back to allow edits/additions to this linked table.
Click to expand...

If you have MS Office Access 2003 and just installed MS Office SP-2, or if
you have MS Access 2002 and installed the KB904018 update (issued three weeks
ago) on your computer, then you will experience this new problem. It's not a
bug. It's by design, because Microsoft had some legal issues about this so
disabled this feature for its customers.

If you have installed MS Office 2003 SP-2, then it can't be uninstalled.
You'll need to revert to an earlier backup of your computer or else uninstall
Office (yes, the entire suite if it's installed on your computer, not just
the stand-alone Access application), then reinstall it and apply SP-1, but
not SP-2.

For more information, please see the following Web page:

http://support.microsoft.com/kb/904953/en-us

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
Back
Top