Excel linked into Access (2003 fo both)

[FaFan]

Hi,

I'm linking an Excel file to a Access DB. On one computer, I can modify the
data both way (from Excel to Access and vice versa) but on another computer
(same configuration), I can only change the data from Excel to Access, not
from Access to Excel.

In table view, I don't have the Add button available.

Any ideas?

Thanks

 

[Chris O'C via AccessMonster.com]

It's not the same config. On the pc with the Access 2003 installation where
you can update a linked spreadsheet, Office 2003 sp2 hasn't been installed
yet. Office 2003 sp2 or later is already installed on the other pc, so you
can't add, update or delete rows in linked spreadsheets.

http://support.microsoft.com/kb/904953

Chris
Microsoft MVP