Results not going to Database

  • Thread starter Thread starter Steve Grosz
  • Start date Start date
S

Steve Grosz

Ok, I think I've got everything set up correctly. Have all the fields on
the form mapped to database fields. Have a ODBC connection made to my
Access database.

When I press submit, the results page comes up, but when I open my database,
nothing is in there.

Any ideas? I'm getting a message about Microsoft Jet needing to be updated,
but that's all that I see when opening the database.

I'm confused!!

Steve
 
-----Original Message-----
Ok, I think I've got everything set up correctly. Have
all the fields on the form mapped to database fields.
Have a ODBC connection made to my Access database.

When I press submit, the results page comes up, but when
I open my database, nothing is in there.
Click to expand...

The usual reason for this is either:

o A database field name that's a reserved word (such as
date, time, or timestamp).
o A database field name that contains spaces or special
characters.
o Lack of file system permissions to update the database.
a reserved equals
Any ideas? I'm getting a message about Microsoft Jet
needing to be updated, but that's all that I see when
opening the database.
Click to expand...

Is this message appearing in some circumstance other than
submitting the form, then? When, exactly, does it occur?

The usual fix is to download and install the most recent
version of the Microsoft Data Access Components (MDAC) on
the Web server. You can get these from:

http://msdn.microsoft.com/nhp/Default.asp?
contentid=28001860

However, if you're not sure you want to do this, post
again tot his thread and explain exactly when you get the
message about Microsoft Jet needing to be updated.

Jim Buyens
Microsoft FrontPage MVP
(e-mail address removed)
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*
 
The Microsoft Jet message is showing up after I submit the form and then try
to open the database in Access. When I submit the form, there is no error
message, everything appears to have worked just fine.
 
Steve Grosz said:
The Microsoft Jet message is showing up after I submit the form and then try
to open the database in Access. When I submit the form, there is no error
message, everything appears to have worked just fine.
Click to expand...

How did you create the database?

What version of Access are you using?

Jim Buyens
Microsoft FrontPage MVP
(e-mail address removed)
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*
 
I am using Access 2002. I have it installed on my Wk2 server. I logged in
remotely to the W2k box, created the Access database, and saved it in the
folder I wanted on the server.

Steve
 
Make sure the db is stored in the fpdb folder.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
I thought that was the whole idea of setting up a ODBC connection, that you
could store a database anywhere on the server that you wanted to.

Am I wrong?
Steve
 
Steve,

If you store it anywhere else, the server Admin must set permissions on the
folder and the database, whereas using the fpdb folder, FP will set the
permission for you.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
Back
Top