Error when updating an access database

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I used the database interface wizard to create a way to
add,delete and update records on a database it worked
great for the last year now all of a sudden I can only
add records and cannot update-edit or delete records. Has
any one else had this problem?

I researched in in the KBase and tried what was suggested
but it still doesn't work. I even tried to recreate it
on a test server and it won't work either. Does anyone
know if the newer FP extensions or the .Net framework
have anything to do with this?

I am currently running the XP version of FrontPage
 
I don't remember any changes that I am aware of.

When you use the database interface wizard it creates
pages to add, delete and update-edit records in the
database. It has worked great for about a year. Now I am
able to add records, but if I try to delete or update a
record I get the following message


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

I don't know if the ISP updated the extensions,
added .Net Framework or what but I have had this happen
on 2 different sites that are hosted on 2 different
ISP's. That is why I wondered if it had something to do
with extension or .NET

I added some code <%=request.querystring%> above the data
regions on the update.asp, edit.asp and delete.asp to
see what was coming in (being passed to) these pages.

The edit page is passed the record number which is then
used to populate the form fields with the data for that
record, but the other 2 pages aren't receiving anything
which seems really weird.

As an example the update page should be receiving all of
the parameters and values that are going to be updated
but nothing appears to be passed to this page.

I don't know what to do at this point I am just fishing
for some ideas

Hope my explanation made more sense this time

Thanks

-----Original Message-----
Hi Tom,

There is insufficient information here to be of much
Click to expand...
help. Where there any error messages? Has anything
changed since it was
working?


--
Mike -- FrontPage MVP '97-'02
http://www.websunlimited.com
J-Bots Plus 2002 87 components for FrontPage
http://www.websunlimited.com/order/Product/JBP2002/jbp_he lp_dir.htm
FrontPage Add-ins Since '97 2003 / 2002 / 2000 Compatible

"Tom" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
Actually on both. It started on the live web site. So I
brought the site down to my local system and was still
getting the same errors.

I am trying to resolve it on my local system then will
migrate it back to the server. All of the web site works
fine except this one part. The areas that I have that
display data from the data base for the site work fine.
as I said earlier it is only the pages that deal with
updating and deleting records that won't work any more.
It is really puzzling because it has worked great for so
long. I even tried to regenerate it on my local system
and still keep getting the same errors.

I have not recently installed any service packs but as
far as I know my service packs are up to date. I tried
to install one the other day after this happened and when
I went to install it it said that i was up to date on my
service packs.
 
Hi

I have had exactly the same problem for a few months and have had to hand
code some pages just to keep the sites running.

It seems an MS update really messed up something so that custom DRW's fail
to work. Update, delete and distinct no longer perform.

I even went to MS's paid support and was refused any support!

If you find a solution beyond rewriting by hand let me know!

M
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Database Editor Problems 7
Database interface wizard 1
Database wizzard- can only view, but not edit, delete or add records 6
database edit 5
FP2003 & Access Database Problem 6
Allowing users to enter, and later update, information via the web 4
Database Update 16
FP-2003 Database wizard missing 2

Back
Top