|
| |
|
|
IronWill
Posts: 103
Joined: 3/8/2007
Status: offline
 |
Microsoft Access URL checker? - 2/7/2008 16:57:21
Hi!
Does anyone know of a program, add-in or script one can use for checking URLs in Microsoft Access?
I have a database table with about 900 URLs, each of which I would like to be able to verify as working (or not), and it would be great if I could do so with just the click of a button.
Thanks!
|
|
|
|
IronWill
Posts: 103
Joined: 3/8/2007
Status: offline
|
RE: Microsoft Access URL checker? - 2/11/2008 9:55:01
bump...
| |
|
|
|
ou812
Posts: 1538
Joined: 1/5/2002
From: San Diego
Status: offline
|
RE: Microsoft Access URL checker? - 2/11/2008 11:37:44
Here's someone who is trying to do something like you're asking: http://www.webmaster-talk.com/asp-forum/60125-asp-ping-results-to-database.html
In his first example, I would change it so you read in your URLs from your database and then just loop through each one. Then, you can either use the next example to write to the database, or modify it a bit to just display the ones that didn't ping.
_____________________________
-brian
EnterpriseDB: Enterprise-class relational database management system
PostgreSQL: The world's most advanced open source database
| |
|
|
|
IronWill
Posts: 103
Joined: 3/8/2007
Status: offline
|
RE: Microsoft Access URL checker? - 2/11/2008 15:29:11
Thanks for the reply.
That script looks more like its meant to insert information *into* a database though? I'm not sure I see how it applies in my case since I'm trying to have all the URLs currently in my database tested ("pinged"). I'm not trying to directly update my database tables, I just want to know if any of the URLs in them are bad without my having to test them all by hand...
| |
|
|
|
ou812
Posts: 1538
Joined: 1/5/2002
From: San Diego
Status: offline
|
RE: Microsoft Access URL checker? - 2/11/2008 15:36:17
Yes, but just try out the first posting, where it works to display online or not. If that code works (I don't have time to give it a whirl right now, but the op acts as it does) then build your looping around it to pass in your URLs from your database, and then just display those URLs that are not online.
<edit> I just tried out the code, and it works. So, it is just a matter of you reading in your URLs from your database, maybe into an array, and then loop through your array using the code provided</edit>
<edit2>Another thing you may need to be aware of, some hosts do not allow pinging of their sites so this may fail on some sites. Something you would need to verify if you get an offline message</edit2>
< Message edited by ou812 -- 2/11/2008 15:46:49 >
_____________________________
-brian
EnterpriseDB: Enterprise-class relational database management system
PostgreSQL: The world's most advanced open source database
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
