DB Wizard - cannot edit

[Veronika]

Hi;

I' ve generated ASP files from MS database with the DB wizard template. I
can add data, delete, but cannot edit records. I get the following message:

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


Why?
Also, the Access database has some fields specified as "drop down", some
fields have "mask" - postal code, date etc. However the wizard totally
ignore these and creates everything the same? How can I ensure that the
field specification get picked up?

Thanks

Veronika

 

[Bob Lehmann]

I' ve generated ASP files from MS database with the DB wizard template.
I'm sorry.

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

Please contact your server administrator since you have no idea what you are
doing.

Why?

Why what? Why was there an an error? Why should you contact your server
administrator?

Also, the Access database has some fields specified as "drop down",
How can I ensure that the field specification get picked up?

By only using Access instead of technologies you have no clue about.

Bob Lehmann

 

[Veronika]

Bob, if you cannot assist, don't bother replying...

 

[Thomas A. Rowe]

When you use the Access database on the web you are not using Access, so you do not have access to
any of the Access application built-in functions, etc. You would have to learn to hand code with ASP
to duplicate, etc.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Stefan B Rusynko]

To see more info on the errors , open the hidden folder /_fpclass/ and edit the fpdbrgn1.inc file

At about line 19, change :
fp_DEBUG = False
to :
fp_DEBUG = True


--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hi;
|
| I' ve generated ASP files from MS database with the DB wizard template. I
| can add data, delete, but cannot edit records. I get the following message:
|
| Database Results Error
| The operation failed. If this continues, please contact your server
| administrator.
|
|
| Why?
| Also, the Access database has some fields specified as "drop down", some
| fields have "mask" - postal code, date etc. However the wizard totally
| ignore these and creates everything the same? How can I ensure that the
| field specification get picked up?
|
| Thanks
|
| Veronika
|
|

 

[Veronika]

I was using the database wizard build within the Front Page 2002. I've tried
it two different ways (once I created the db first and told the wizard to
use existing db, 2nd time I let the wizard create new db [ Create New Web
with Database Interface Wizard]) both have the same problem.
I login it with acct/password to see the data, I can use the add or delete
record functions, but when I select the numeric hyperlink to the record, it
will display it in the lower frame O.K. but when I select the edit link and
make changes I than generate the error.

Thanks
Veronika

 

[Veronika]

Thanks I got expended message now, so I just have to find out how to provide
a default values when the wizard is generating this form.

Veronika

Database Results Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine

One or more form fields were empty. You should provide default values for
all form fields that are used in the query.

 

[Stefan B Rusynko]

It means you must have a valid date entry for all required fields

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Thanks I got expended message now, so I just have to find out how to provide
| a default values when the wizard is generating this form.
|
| Veronika
|
| Database Results Error
| Description: Syntax error in UPDATE statement.
| Number: -2147217900 (0x80040E14)
| Source: Microsoft JET Database Engine
|
| One or more form fields were empty. You should provide default values for
| all form fields that are used in the query.
|
|
| | > To see more info on the errors , open the hidden folder /_fpclass/ and
| > edit the fpdbrgn1.inc file
| >
| > At about line 19, change :
| > fp_DEBUG = False
| > to :
| > fp_DEBUG = True
| >
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | > | Hi;
| > |
| > | I' ve generated ASP files from MS database with the DB wizard template.
| > I
| > | can add data, delete, but cannot edit records. I get the following
| > message:
| > |
| > | Database Results Error
| > | The operation failed. If this continues, please contact your server
| > | administrator.
| > |
| > |
| > | Why?
| > | Also, the Access database has some fields specified as "drop down", some
| > | fields have "mask" - postal code, date etc. However the wizard totally
| > | ignore these and creates everything the same? How can I ensure that the
| > | field specification get picked up?
| > |
| > | Thanks
| > |
| > | Veronika
| > |
| > |
| >
| >
|
|

 

[Stefan B Rusynko]

Correction: date should be data

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| It means you must have a valid date entry for all required fields
|
| --
|
| _____________________________________________
| SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| "Warning - Using the F1 Key will not break anything!" (-;
| To find the best Newsgroup for FrontPage support see:
| http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| _____________________________________________
|
|
|| Thanks I got expended message now, so I just have to find out how to provide
|| a default values when the wizard is generating this form.
||
|| Veronika
||
|| Database Results Error
|| Description: Syntax error in UPDATE statement.
|| Number: -2147217900 (0x80040E14)
|| Source: Microsoft JET Database Engine
||
|| One or more form fields were empty. You should provide default values for
|| all form fields that are used in the query.
||
||
|| || > To see more info on the errors , open the hidden folder /_fpclass/ and
|| > edit the fpdbrgn1.inc file
|| >
|| > At about line 19, change :
|| > fp_DEBUG = False
|| > to :
|| > fp_DEBUG = True
|| >
|| >
|| > --
|| >
|| > _____________________________________________
|| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
|| > "Warning - Using the F1 Key will not break anything!" (-;
|| > To find the best Newsgroup for FrontPage support see:
|| > http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
|| > _____________________________________________
|| >
|| >
|| > || > | Hi;
|| > |
|| > | I' ve generated ASP files from MS database with the DB wizard template.
|| > I
|| > | can add data, delete, but cannot edit records. I get the following
|| > message:
|| > |
|| > | Database Results Error
|| > | The operation failed. If this continues, please contact your server
|| > | administrator.
|| > |
|| > |
|| > | Why?
|| > | Also, the Access database has some fields specified as "drop down", some
|| > | fields have "mask" - postal code, date etc. However the wizard totally
|| > | ignore these and creates everything the same? How can I ensure that the
|| > | field specification get picked up?
|| > |
|| > | Thanks
|| > |
|| > | Veronika
|| > |
|| > |
|| >
|| >
||
||
|
|