I have a linked file from Excel to my Access database. All worked well and I was able to edit it in Access. I have just installed Office XP service pack 3, and now everytime I try to edit my linked excel file in access, I just get a ringing bell. Urgent help needed please as it's my business database. I have tried relinking the file but still no success.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access wont allow me to edit linked excel file
- Thread starter piaff1
- Start date
- Thread starter
- #3
I have found the answer. Microsoft update for Access 2002 SP3 disables the ability to edit linked files in Access. Their workaround is to open the files in Excel and then it will change the contents of linked file in Access. This totally destroys the purpose of my database. This update to Access cannot be removed! Thanks a bunch Microsoft!
- Status
Similar threads
- Locked
- Question