Difference between SP1 And SP2

[Jay Bukstein]

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?

 

[Douglas J. Steele]

You can replace the spreadsheet using TransferSpreadsheet, or you can use
Automation.

 

[Chris Mills]

This might be off-topic, but one of my customers expected a "formatted
spreadsheet" (like a Report he thought) whereas TransferSpreadsheet 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

 

[Graham R Seach]

Chris,

Just a thought - if you want to send a formatted spreadsheet, create a
template replete with formatting and named ranges. Use TransferSpreadsheet
to push the data into the named ranges. That way, you get to keep the Excel
formatting.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Jay Bukstein]

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 spreadsheet, and on SP2 I get an
error that states the Query must be updatable, but this very same code works

 

[Chris Mills]

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 (Transferspreadsheet) 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

 

[Chris Mills]

I could run an update query to a linked xls, Access2002 SP2. (A2000 file
format!)

Of course, my test involved a very simple query!

Chris