I have created a data gathering form using FP2002. I have setup the data
connections using the DB wizard. Everything looks good. The connection looks
good, I do not get any errors. I had the wizard create the DB for me, without
a problem. But when I submit the form, the data does not post to the DB? It
says form has been submitted, but there is nothing updated in the database.
Any suggestions or is there something I am missing here?

What is the code you are using?


"R" <(E-Mail Removed)> wrote in message
news:4AA36B0D-5088-49CF-9B14-(E-Mail Removed)...
>I have created a data gathering form using FP2002. I have setup the data
> connections using the DB wizard. Everything looks good. The connection
> looks
> good, I do not get any errors. I had the wizard create the DB for me,
> without
> a problem. But when I submit the form, the data does not post to the DB?
> It
> says form has been submitted, but there is nothing updated in the
> database.
> Any suggestions or is there something I am missing here?

I am using .asp, I have just created a form and want others input in the
fields of the form and the database to upload the information. At this time,
it is on the local machine and I am testing. But the database is not updating
with the inputs.

"David Berry" wrote:

> What is the code you are using?
>
>
> "R" <(E-Mail Removed)> wrote in message
> news:4AA36B0D-5088-49CF-9B14-(E-Mail Removed)...
> >I have created a data gathering form using FP2002. I have setup the data
> > connections using the DB wizard. Everything looks good. The connection
> > looks
> > good, I do not get any errors. I had the wizard create the DB for me,
> > without
> > a problem. But when I submit the form, the data does not post to the DB?
> > It
> > says form has been submitted, but there is nothing updated in the
> > database.
> > Any suggestions or is there something I am missing here?
>
>
>

The first thing I would recommend is to make sure you're not using any
reserved words for and/or special characters in your database fieldnames:
http://support.microsoft.com/default...b;en-us;286335 and
http://support.microsoft.com/?id=321266 and
http://support.microsoft.com/?id=826763

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


"R" <(E-Mail Removed)> wrote in message
news:936FE443-774C-4487-A194-(E-Mail Removed)...
>I am using .asp, I have just created a form and want others input in the
> fields of the form and the database to upload the information. At this
> time,
> it is on the local machine and I am testing. But the database is not
> updating
> with the inputs.
>
> "David Berry" wrote:
>
>> What is the code you are using?
>>
>>
>> "R" <(E-Mail Removed)> wrote in message
>> news:4AA36B0D-5088-49CF-9B14-(E-Mail Removed)...
>> >I have created a data gathering form using FP2002. I have setup the data
>> > connections using the DB wizard. Everything looks good. The connection
>> > looks
>> > good, I do not get any errors. I had the wizard create the DB for me,
>> > without
>> > a problem. But when I submit the form, the data does not post to the
>> > DB?
>> > It
>> > says form has been submitted, but there is nothing updated in the
>> > database.
>> > Any suggestions or is there something I am missing here?
>>
>>
>>

Yes but what's the ASP code so we can see if there are any errors.


"R" <(E-Mail Removed)> wrote in message
news:936FE443-774C-4487-A194-(E-Mail Removed)...
>I am using .asp, I have just created a form and want others input in the
> fields of the form and the database to upload the information. At this
> time,
> it is on the local machine and I am testing. But the database is not
> updating
> with the inputs.
>
> "David Berry" wrote:
>
>> What is the code you are using?
>>
>>
>> "R" <(E-Mail Removed)> wrote in message
>> news:4AA36B0D-5088-49CF-9B14-(E-Mail Removed)...
>> >I have created a data gathering form using FP2002. I have setup the data
>> > connections using the DB wizard. Everything looks good. The connection
>> > looks
>> > good, I do not get any errors. I had the wizard create the DB for me,
>> > without
>> > a problem. But when I submit the form, the data does not post to the
>> > DB?
>> > It
>> > says form has been submitted, but there is nothing updated in the
>> > database.
>> > Any suggestions or is there something I am missing here?
>>
>>
>>