Problem linking to website with Access

Andrew W

Hi All,

I'm trying to link to data on a website with Access. When I try File/
Get External Data/ link tables/ HTML/, I get the following error
message:

Database or object is read-only.

I find this odd because I can get this data thru Excel's web query
function.

Any ideas or alternative approaches would be appreciated!

Andrew

Mar 19 '07 #1

'69 Camaro

Hi, Andrew.

Database or object is read-only.

Is the file extension HTML or HTM? If not, you'll get this error message.
Or if you have certain combinations of Windows operating systems, Microsoft
Office, Jet, MDAC, and their service packs, you'll get this error message.
When we find out which ones you have we can make a recommendation on how to
fix it. I'm going out of town shortly so someone else will probably have to
diagnose the problem should you be willing to reveal the pertinent
information.

I find this odd because I can get this data thru Excel's web query
function.

Linking to an updateable data source isn't quite the same thing. Your
observation that this is odd behavior is rather like arguing "What do you
mean my check bounced? There's no way it could bounce. I still have checks
in my checkbook!"

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Andrew W" <we*****@earthlink.netwrote in message
news:11**********************@n76g2000hsh.googlegr oups.com...

Hi All,

I'm trying to link to data on a website with Access. When I try File/
Get External Data/ link tables/ HTML/, I get the following error
message:

Database or object is read-only.

I find this odd because I can get this data thru Excel's web query
function.

Any ideas or alternative approaches would be appreciated!

Andrew

Mar 19 '07 #2

Andrew W

On Mar 19, 11:05 am, "'69 Camaro" <ForwardZERO_SPAM.To.
69Cam...@Spameater.orgZERO_SPAMwrote:

Hi, Andrew.

Database or object is read-only.

Is the file extension HTML or HTM? If not, you'll get this error message.
Or if you have certain combinations of Windows operating systems, Microsoft
Office, Jet, MDAC, and their service packs, you'll get this error message.
When we find out which ones you have we can make a recommendation on how to
fix it. I'm going out of town shortly so someone else will probably have to
diagnose the problem should you be willing to reveal the pertinent
information.

I find this odd because I can get this data thru Excel's web query
function.

Linking to an updateable data source isn't quite the same thing. Your
observation that this is odd behavior is rather like arguing "What do you
mean my check bounced? There's no way it could bounce. I still have checks
in my checkbook!"

HTH.
Gunny

Seehttp://www.QBuilt.comfor all your database needs.
Seehttp://www.Access.QBuilt.comfor Microsoft Access tips and tutorials.
Blogs:http://www.DataDevilDog.BlogSpot.com...utors2.htmlfor contact
info.

"Andrew W" <weit...@earthlink.netwrote in message

news:11**********************@n76g2000hsh.googlegr oups.com...

Hi All,

I'm trying to link to data on a website with Access. When I try File/
Get External Data/ link tables/ HTML/, I get the following error
message:

Database or object is read-only.

I find this odd because I can get this data thru Excel's web query
function.

Any ideas or alternative approaches would be appreciated!

Andrew- Hide quoted text -

- Show quoted text -

Hi Gunny, thanks for the response.

The target file extension is html. I'm using Access 2002 in Windows
XP. I'm pretty current on updates (SP3).

Mar 21 '07 #3