Re: Difference between SP1 And SP2

OK, it's a "Query not updateable" issue.
Apparently it's a difference between SP1 and SP2 (A2002 I see)
One "Query not updateable" issue was "fixed" in SP2 :-)

I vaguely recall Jerry Whittle's reply now (because of the interesting
mentioned patent dispute). You have not said whether that addressed your
issue. For example, I'd create the simplest possible test-UpdateQuery (single
table) and try updating an xls linked table.

It may be that the other methods (Transferspread***) don't fall into the
dispute.

I didn't see any excel fixes at http://support.microsoft.com/kb/836030/, but
maybe it's worth trying SP3. The updates don't seem to mention the dispute.
Here's the dispute:
http://www.theregister.co.uk/2006/02/07/microsoft_office_access_infringement/

Chris

"Jay Bukstein" <JayBukstein@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1816A8AD-0CC7-4619-9557-9D819823D2D0@xxxxxxxxxxxxxxxx
My problem is I have an Access database that converts codes from SQL and
build a table that get copied into Excel. I have a updatable Query that
copies the Access data to a Linked Excel spread***, and on SP2 I get an
error that states the Query must be updatable, but this very same code works
on SP1 and prior.



"Chris Mills" wrote:

This might be off-topic, but one of my customers expected a "formatted
spread***" (like a Report he thought) whereas TransferSpread*** just
transfers the data in a basic unformatted xls layout.

I guess Doug covered that in that you can use Automation.

It was easier for me to discard the customer in my case <guffaw>

SP differences are usually listed in excruciating detail on MS Website
aren't
they? I never wait for them if I have a problem (so many remain).

There is no indication in your re-post exactly what your problem is, Jay.
Workaround for what?

SP1 and SP2 of what version of what exactly?

Chris

"Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx> wrote in message
news:OP6PPhq9GHA.4196@xxxxxxxxxxxxxxxxxxxxxxx
You can replace the spread*** using TransferSpread***, or you can
use
Automation.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Jay Bukstein" <JayBukstein@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EC05DC71-A4D3-4A46-83C7-263137F3E7B7@xxxxxxxxxxxxxxxx
On the 9/14 I asked for those difference. I did recieve part of what I
was
looking for. Looks like one of my Access databases has a linked Excel
table
that needs to be updated to display.

Is there any work arounds for this that don't violate the lawsuit that
Microsoft lost?








.

Loading