At least you admit it! Most people just say, "I haven't changed anything!
It just stopped working! I think it's a bug!"
You should always make sure that you only change database connections via
the dialog in FrontPage. FrontPage writes information all over the place
when you add connections.
FrontPage_UrlVars should be dimmed with the number of connections in your
Web site. There should then be a section for each connection. The error
you are getting indicates to me that the connection is there, but it's
damaged.
FrontPage will move into the code block you are hanging on if a variable
called fp_fError evaluates to True. There are a TON of things that can
cause this variable to be true, so it's very hard to say what the issue is.
I would begin by using the Database tab on Web Settings (or Site Settings in
FP2003) to remove ALL database connections and then recreate them. See if
that helps.
--
Jim Cheshire
Jimco Add-ins
Add-ins for FrontPage 2000-2003
http://www.jimcoaddins.com
===============================
Co-author of Special Edition
Using Microsoft FrontPage 2003