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

> 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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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, if you cannot assist, don't bother replying...

"Bob Lehmann" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> 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
>>
>>
>
>

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.
==============================================

"Veronika" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)...
> 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
>

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/FrontPa...3/Default.aspx
_____________________________________________


"Veronika" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)...
| 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
|
|

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
"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:%239J3$(E-Mail Removed)...
> 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.
> ==============================================
>
> "Veronika" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> 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
>>
>
>

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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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/FrontPa...3/Default.aspx
> _____________________________________________
>
>
> "Veronika" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> | 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
> |
> |
>
>

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/FrontPa...3/Default.aspx
_____________________________________________


"Veronika" <(E-Mail Removed)> wrote in message news:uQ$(E-Mail Removed)...
| 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" <(E-Mail Removed)> wrote in message
| news:%(E-Mail Removed)...
| > 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/FrontPa...3/Default.aspx
| > _____________________________________________
| >
| >
| > "Veronika" <(E-Mail Removed)> wrote in message
| > news:%(E-Mail Removed)...
| > | 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
| > |
| > |
| >
| >
|
|

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/FrontPa...3/Default.aspx
_____________________________________________


"Stefan B Rusynko" <(E-Mail Removed)> wrote in message news:%23oKd$(E-Mail Removed)...
| 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/FrontPa...3/Default.aspx
| _____________________________________________
|
|
| "Veronika" <(E-Mail Removed)> wrote in message news:uQ$(E-Mail Removed)...
|| 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" <(E-Mail Removed)> wrote in message
|| news:%(E-Mail Removed)...
|| > 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/FrontPa...3/Default.aspx
|| > _____________________________________________
|| >
|| >
|| > "Veronika" <(E-Mail Removed)> wrote in message
|| > news:%(E-Mail Removed)...
|| > | 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
|| > |
|| > |
|| >
|| >
||
||
|
|