By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,561 Members | 3,010 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,561 IT Pros & Developers. It's quick & easy.

access to website links

P: n/a
I had sent this message earlier and thought I would try again - Is there
a way to hook up an access database to an on-line database (for example,
for the International Labour Organization Database) for specific tables
so that when the internet database is updated, the updates are done
automatically in the access database also for the
selected tables? How would be the best way to do this?

Thanks, and looking forward to your ideas.

Dave Shapiro

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
david shapiro wrote:
I had sent this message earlier and thought I would try again - Is there
a way to hook up an access database to an on-line database (for example,
for the International Labour Organization Database) for specific tables
so that when the internet database is updated, the updates are done
automatically in the access database also for the
selected tables? How would be the best way to do this?

Thanks, and looking forward to your ideas.

Dave Shapiro


You've asked the same question at least 3 times. I'm not sure a
"website" is what you need. I think you'd need a link to their database.

Perhaps what is needed is that you create an ODBC link to their database
and the tables there. Then you can have a link to their data and not be
going through a "website". In order to do that, you'd need their
permission to do so. You should contact them and see if they'll let you
in. Perhaps there can be a connection that is created on the fly where
you pass a password to them that permits you to create some linked tables.

Take a look at the Connect property in help. That might be a starting
point.

Nov 13 '05 #2

P: n/a
david shapiro <da***********@hotmail.com> wrote in message news:<41**********************@news.newsgroups.ws> ...
I had sent this message earlier and thought I would try again - Is there
a way to hook up an access database to an on-line database (for example,
for the International Labour Organization Database) for specific tables
so that when the internet database is updated, the updates are done
automatically in the access database also for the
selected tables? How would be the best way to do this?

Thanks, and looking forward to your ideas.

Dave Shapiro


Ummm yeah, we read this before. I think MG Foster's advice stands.
One reason you may not be getting other responses is that either
nobody disagrees with him... I sure don't. If I spent months or
whatever developing a database with a web front end, I would need a
VERY compelling reason to let someone just use my work for free. Have
you tried contacting whoever developed the database and asked them?
You might start there.
Nov 13 '05 #3

P: n/a
Thanks for the replies on access to an on-line database. Sorry about
the 3 postings, the first time there must have been a glitch in the
internet as the message didn't show up until the following day,
meanwhile I thought it didn't go through so I sent it again. I sent the
other one, not having seen MGFoster's message.

I did try contacting the organization about arranging a direct link to
the database. But they said it wouldn't be possible as they already
make all their data available through their on-line database site.

Ideally, a direct link to the database would be great. But otherwise,
an alternative solution might be some kind of link to specific data
tables if that is possible some way.

Would appreciate if you have any more ideas on this. Thanks.

Dave Shapiro

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #4

P: n/a
"david shapiro" <da***********@hotmail.com> wrote in message
news:41**********************@news.newsgroups.ws.. .
I had sent this message earlier and thought I would try again - Is there
a way to hook up an access database to an on-line database (for example,
for the International Labour Organization Database) for specific tables
so that when the internet database is updated, the updates are done
automatically in the access database also for the
selected tables? How would be the best way to do this?

I helped my son make a sample database for a school project that does
something similar - it fetches stock prices from a web page, (in this case I
think it was yahoo financials), and strips out the stock prices by parsing
the returned html. This is really clumsy stuff - if the website ever changes
the code will break - if I were going to do this sort of thing in a
real-world app I'd use a web service. But this way is simple and free so ...

You're welcome to take a look and see if any of it helps you.

http://www.assaynet.com/downloads/stocks.mdb

Look at frmGetStockUpdates.

You could run this sort of code from a form's timer to keep refreshing the
data. If they're monitoring traffic and you do this frequently then expect
to get blocked at some stage for abuse :-)

Nov 13 '05 #5

P: n/a
"John Winterbottom" <as******@hotmail.com> wrote in message
news:2u*************@uni-berlin.de...

You're welcome to take a look and see if any of it helps you.


wrong url, sorry try

http://www.assaynet.com/downloads/access/stocks.mdb
Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.