Microsoft Access URL checker? (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

IronWill -> 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 -> RE: Microsoft Access URL checker? (2/11/2008 9:55:01)

bump...



ou812 -> 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.



IronWill -> 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 -> 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>






Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.078125