Hi,

We have two servers, a development server and a production server.
Supposedly, these two servers are to mirror each other exactly.
Anyway, on our development server, I've built an .asp form in FP2002,
then had FP2002 build an Access 2002 database from it using Form
Properties-->Send to database-->Options...-->Create Database...etc...
This worked great on our development server. I opened the .asp page in
IE, populated the form, clicked submit, and got my confirmation page.
When I checked the Results table in the Access 2002 db FP created for
me, the record was there.

I duplicated the same process on our production server, and everything
appeared to work correctly, however, the form data does not populate
the Access db. What should I check on the production server to
troubleshoot this? Is this a server extension issue? I looked at what
I thought was the folder for these server extensions on both servers,
and the files there appeared identical.

Thank you very much for any assistance provided,

Dave Brandes
dave_brandes@msn.com

[ Post a follow-up to this message ]

Hi Dave,

1. Ensure the anonymous user has permissions to modify the access DB
2. Ensure the web site [with global.asa] that has the DB has been set to
 an
Application

Regards,
Vijay

Disclaimer: This posting is provided "as is" with no warranties and confers
no rights

--------------------
| From: dave_brandes@msn.com (Dave)
| Newsgroups: microsoft.public.frontpage.extensions.windowsnt
| Subject: FrontPage .asp form not populating Access database
| Date: 18 Mar 2004 09:19:23 -0800|
| Hi,
|
| We have two servers, a development server and a production server.
| Supposedly, these two servers are to mirror each other exactly.
| Anyway, on our development server, I've built an .asp form in FP2002,
| then had FP2002 build an Access 2002 database from it using Form
| Properties-->Send to database-->Options...-->Create Database...etc...
| This worked great on our development server. I opened the .asp page in
| IE, populated the form, clicked submit, and got my confirmation page.
| When I checked the Results table in the Access 2002 db FP created for
| me, the record was there.
|
| I duplicated the same process on our production server, and everything
| appeared to work correctly, however, the form data does not populate
| the Access db. What should I check on the production server to
| troubleshoot this? Is this a server extension issue? I looked at what
| I thought was the folder for these server extensions on both servers,
| and the files there appeared identical.
|
| Thank you very much for any assistance provided,
|
| Dave Brandes
| dave_brandes@msn.com
|

[ Post a follow-up to this message ]