Long story short...
I have two archived forums built on the Snitz platform(ASP/Access DB).
They resided under one Domainname since 2002.(hxxp://xxx.olddomain.ws)
We've since changed domain names to (hxxp://xxxnewdomain.com) and moved everything from one server/host to another.
Both Forums are now archived successfully and live for viewing to all registered members.
The trouble is many posts that users had uploaded images and files to still have the old address we no longer have access to which creates a Red X situation where the images no longer show.
My question is....how do I manipulate the database to find and replace the old URL with the new one?
Is there a script I can run?
Am I stuck editting each post made....?
47,000+?
I'm stuck and I know little about sql and relational databases.
Any help would be appreciated.

Thank You