UPDATE statement not working

[Chad_Nichols]

Howdy. I've recently migrated to a new Windows 2003 Server. All database
files from previous server (Windows 2000 Server) were published in FrontPage
2003 to this new server and function just fine. Unfortunately, though, any
new pages I create from scratch on the server do not function properly when
utilizing the UPDATE statement. I receive this error:

"Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator."

Backend is MS Access. I've completely simplified the query to a really
simple string just to rule out any typos --- fpdeparture is a text field and
fpid is numeric. This is the string:

UPDATE tblFlightplan
SET fpdeparture='::fpdeparture::'
WHERE fpid=::fpid::

Any ideas why I am unable to utilize the UPDATE statement on any new pages I
create? All other ASP pages function normally. Thanks! Chad.

Chad Nichols

 

[Chad_Nichols]

OK, disregard.... Just identified Kathleen Anderson's post from 7/3/2004
referencing a thread at http://www.frontpagewebmaster.com/m-175524/tm.htm ---
This thread indicates the idea of replacing fpdblib.inc, fpdbrgn1.inc, and
fpdbrgn2.inc with FP2000 versions and all is well. Yes, for those of you who
end up in this same quandry, the FP2000 version of the files are downloadable
at that particular thread. Chad.