Gustav Brock
Gustav at cactus.dk
Tue Oct 25 09:59:39 CDT 2005
Hi Marty et all Please note that is relevant for Access 2002/XP as well! In Microsoft Office Access 2003 or in Microsoft Access 2002, you cannot change, add, or delete data in tables that are linked to a Microsoft Excel workbook. This expected behavior occurs when either of the following conditions is true: You have installed Microsoft Office 2003 Service Pack 2 (SP2). You have installed the update for Access 2002 (KB904018) that is dated October 18, 2005. Thus it does not disable linking of Excel tables but disables update, delete, or append "only". Tables can still be read. /gustav >>> martyconnelly at shaw.ca 24-10-2005 21:28:58 >>> Just a heads up on this recent Access 2003 SP, it will disable linking to Excel files. So you may not want to apply it. http://support.microsoft.com/kb/904953/en-us It is because of this patent ruling http://news.com.com/Patent+ruling+costs+Microsoft+8.9+million/2100-1007_3-5735432.html -- Marty Connelly Victoria, B.C. Canada