Can't run Update Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an access database that has an update query in it that updates a
linked excel sheet. Everything was working fine until the IT guys at work
got me a new machine. Now, I get an error that the sheet is not updateable.
When I just open the linked sheet and try and manually change the data or add
a record, I'm unable too.

I went to a co-workers machine that uses the same file and they can run it
no problem. So, in further testing, I created a brand new access database
and a brand new excel sheet and linked the excel sheet into the database and
can't alter any of the data that way either.

My IT guys have taken a look at it and are stumped.

So, question is, can anyone think of some security setting that might exist
on the new machine that may be preventing this (my machine is running Windows
XP and access is 2002 w/ SP 3)?
 
JC said:
I have an access database that has an update query in it that updates a
linked excel sheet. Everything was working fine until the IT guys at work
got me a new machine. Now, I get an error that the sheet is not
updateable.
When I just open the linked sheet and try and manually change the data or
add
a record, I'm unable too.

I went to a co-workers machine that uses the same file and they can run it
no problem. So, in further testing, I created a brand new access database
and a brand new excel sheet and linked the excel sheet into the database
and
can't alter any of the data that way either.

My IT guys have taken a look at it and are stumped.

So, question is, can anyone think of some security setting that might
exist
on the new machine that may be preventing this (my machine is running
Windows
XP and access is 2002 w/ SP 3)?
Click to expand...

If you have been upgraded to Office 2k3 *SP2* then links to Excel from
Access are read-only. You'll now have to use Office Automation in VBA code
to update your spreadsheets.

Keith.
www.keithwilby.com
 
Back
Top