OK
So did you rename your DB fields in Access to not use the reserved words as filed names
- you will find a more comprehensive list of reserved names at
http://www.aspfaq.com/show.asp?id=2080
And after that what specific error did you get
--
|I am having the same error and this is what I have found:
| ( it;s kinda hard to follow so try and keep up)
| Someone told me:
| The FP2003 code has changed slightly. To see the true error, open the hidden
| folder /_fpclass/ and edit the fpdbrgn1.inc file
| At about line 19, change :
| fp_DEBUG = False
| to :
| fp_DEBUG = True
| Now I did this and you get a more detailed error message same one just more
| info.
| Sadly I can't tell you the message exactly right now as I need a password to
| access the website and I don't know the password.(my boss does)
| But I do know what it meant.
| It mentioned that one or several fields were empty. There are required
| feilds in your forms. The thing is I don't know which ones. We tried giving
| every one of the fields a default entry. The database has to query each of
| the required entries in order to update the page, otherwise it doesn't know
| what to update. If it is left empty then there are too many records you could
| be referencing and it doesnt know which one you want to update, but if you
| have a default in one that isn't required then something goes wrong. I
| haven't quite figured that out yet. So I am assuming if we can find the
| fields that are required and have a default query for them and no others it
| should work. We tried looking it up on the internet fand ran into another
| problem we did not even know we had. There are certain words that you can
| have in a database, but that FrontPage won't enter into the database. such as
| date, year, and some others.Here is the site we went to:
|
http://support.microsoft.com/kb/q109312/
| I don't know where to go from here.?????? I hope this helps someone so they
| can help me!?!?!?!?!?!?
|
|
| "rifraf" wrote:
|
| > I've been looking through these pages you kindly provided me... but none seem
| > to apply to my situation. These seem to be very specific, while my error
| > message does not seem to give much of a description as to what the problem
| > could be... I'll keep looking through these pages...
| >
| > "Teri Carnright" wrote:
| >
| > > See if any of these look helpful:
| > >
| > >
http://search.microsoft.com/search/results.aspx?st=b&na=88&View=en-us&qu=database+results+error
| > >
| > >
| > >
| > > "rifraf" wrote:
| > >
| > > > I have verified the database... I've even se up a brand new database just the
| > > > test it.. It seems to go flawlessly on my computer in Frontpage... but once I
| > > > publish it.. I get the error. I have already contracted the hosting company -
| > > > they tell me to contact Microsoft. (!) They're no help.
| > > >
| > > > "Teri Carnright" wrote:
| > > >
| > > > > I saw your initial post - what you've given isn't enough to tell me anything
| > > > > except you have serious problems. I'm assuming you have verified the
| > > > > database(s)?? Sometimes, you have to completely remove the existing
| > > > > connection, then add it as a new connection and verify.
| > > > >
| > > > > If that doesn't do it, contact your hosting service immediately - they can
| > > > > likely see what's up by reviewing their error logs.
| > > > >
| > > > > Teri
| > > > >
| > > > >
| > > > >
| > > > > "rifraf" wrote:
| > > > >
| > > > > > Help!... I've had my site up and running for a few weeks - both databases
| > > > > > were working fine. I was away for 3 days, and when i returned, both databases
| > > > > > have mysteriously stopped working. I don't beleive I had made any changes to
| > > > > > the web to incur this. Here is the message I get:
| > > > > >
| > > > > > Database Results Error
| > > > > > The operation failed. If this continues, please contact your server
| > > > > > administrator.
| > > > > >
| > > > > > I've set up a brand new database from scratch (using the database wizard) to
| > > > > > rectify the situation, but I still get the same message. The other database I
| > > > > > am using is a simple login/password using .asp (article 321439) - it too does
| > > > > > not work. I am using FP2002 - and a relative rookie in website design.
