Operation must use an updateable query

  • Thread starter Thread starter countryhouse
  • Start date Start date
C

countryhouse

Ok. I understand that this problem is due to Office sp2, now how can I get
around it, besides the lame methods listed on the Knowledge Base. I am sure
that MS's lawyers told them to state that, but.....

I am about to uninstall the Office sp2, but I am hoping that someone has a
more elegant workaround.

John
 
OH! So I can't uninstall the service pack. How nice!
I sure hope that someone has a fix so that I can update linked Excel queries
with an Access query. Otherwise, my life can become very difficult.

John
 
I don't know if reinstalling Office would help or not. If it does not, there
are ways around your problem; however, they will require some moderate to
advanced VBA skill and, likely, a redesign of your UI. Don't we all love
lawyers?
 
I suspect that I will have to reinstall and hope for the best. My VBA
skills are sketchy. Given enough time, I can figure something out, if its
important., but I think the reinstall will be quicker. Hope it works.

John
 
Hi John,

I don't know if you will consider
this lame also, but..

you can send data to a *new* worksheet
(they call them tables)

SELECT *
INTO
[Excel 8.0;database=C:\test.xls].2006_03_13
FROM qryExcelTopics;

next time

SELECT *
INTO
[Excel 8.0;database=C:\test.xls].2006_03_14
FROM qryExcelTopics;

you just cannot insert into an
existing worksheet any longer.

I did not go back and read MS KB
so maybe you already know this...sorry.

gary
 
Well, if I was in control of the process from the beginning, I would do it
all in Access. Unfortunately, I have the spreadsheet given to me and have a
short time to manipulate the data in some columns and enter new data in a
couple more columns. Then I have to send it on.

I have uninstalled, and reinstalled, and all is OK again. From now on I
will watch for the sp2 upgrade, and make sure I don't accept it.

John
Gary Walter said:
Hi John,

I don't know if you will consider
this lame also, but..

you can send data to a *new* worksheet
(they call them tables)

SELECT *
INTO
[Excel 8.0;database=C:\test.xls].2006_03_13
FROM qryExcelTopics;

next time

SELECT *
INTO
[Excel 8.0;database=C:\test.xls].2006_03_14
FROM qryExcelTopics;

you just cannot insert into an
existing worksheet any longer.

I did not go back and read MS KB
so maybe you already know this...sorry.

gary

countryhouse said:
I suspect that I will have to reinstall and hope for the best. My VBA
skills are sketchy. Given enough time, I can figure something out, if its
important., but I think the reinstall will be quicker. Hope it works.

John
Click to expand...
Click to expand...
 
Back
Top