Differenct between Access XP SP1 and SP2 Jay Bukstein 14.09.2006 15:06:02 I have a Access Db that all the macros and queries run fine until I upgraded the Office SP (version 11) product to SP2. Now I get an error that says 'Operation must be an updatable Query' Nothing has changed in the query. As I said it runs under Version 11 of Aceess sp1 or prior, how or where should I look to fix this? Or what did SP2 do to break this?

RE: Differenct between Access XP SP1 and SP2 Jerry Whittle 15.09.2006 16:01:02 One possibility is if you are linking to Excel spreadsheets and trying to modify data either from Excel to Access or the other way. There is a patent dispute and MS had to turn off this feature. You can still import and export to Excel and even do select statements with queries; however, you can not change data in Excel directly from Access nor Access data from Excel. -- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Jay Bukstein" wrote: [Quoted Text] > I have a Access Db that all the macros and queries run fine until I upgraded > the Office SP (version 11) product to SP2. Now I get an error that says > 'Operation must be an updatable Query' Nothing has changed in the query. > > As I said it runs under Version 11 of Aceess sp1 or prior, how or where > should I look to fix this? > > Or what did SP2 do to break this? > >

Re: Differenct between Access XP SP1 and SP2 "J. Goddard" <jrgoddard[ at ]NO_cyberus_SPAM.ca> 16.09.2006 02:07:46 Interesting. In which version of MS Access was this done? I have A2000, SP3 which still allows this. John Jerry Whittle wrote: [Quoted Text] > One possibility is if you are linking to Excel spreadsheets and trying to > modify data either from Excel to Access or the other way. There is a patent > dispute and MS had to turn off this feature. You can still import and export > to Excel and even do select statements with queries; however, you can not > change data in Excel directly from Access nor Access data from Excel.

Re: Differenct between Access XP SP1 and SP2 "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 16.09.2006 10:47:46 I believe only Access 2002 and 2003 lost the ability to update linked Excel files. The earlier versions managed to escape the change, probably because they're officially out of support. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "J. Goddard" <jrgoddard[ at ]NO_cyberus_SPAM.ca> wrote in message news:eXUcvQT2GHA.4756[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > Interesting. > > In which version of MS Access was this done? I have A2000, SP3 which > still allows this. > > John > > > Jerry Whittle wrote: > >> One possibility is if you are linking to Excel spreadsheets and trying to >> modify data either from Excel to Access or the other way. There is a >> patent dispute and MS had to turn off this feature. You can still import >> and export to Excel and even do select statements with queries; however, >> you can not change data in Excel directly from Access nor Access data >> from Excel. >

Re: Differenct between Access XP SP1 and SP2 Jerry Whittle 16.09.2006 13:00:02 Here's some info: http://www.theregister.co.uk/2006/02/07/microsoft_office_access_infringement/ -- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "J. Goddard" wrote: [Quoted Text] > Interesting. > > In which version of MS Access was this done? I have A2000, SP3 which > still allows this. > > John > > > Jerry Whittle wrote: > > > One possibility is if you are linking to Excel spreadsheets and trying to > > modify data either from Excel to Access or the other way. There is a patent > > dispute and MS had to turn off this feature. You can still import and export > > to Excel and even do select statements with queries; however, you can not > > change data in Excel directly from Access nor Access data from Excel. > >