updating database

[Guest]

I have just purchased FrontPage 2003. I have been able to get information in
a database to print out in a web page. So I have no problem with that.

Here is the issue. I have created a submission forms web page and set it up
to update the database that I am working with. I put all the form fields in
and I tell the form to save the results of the form to a database. I specify
the database, I map the form fields to the column fields and click ok.

I then run the page and I type in all the information and click on the
submit button and it looks like it work and it gives me a confirmation page
and then I go back to the orignial page. I then look in the database and
nothing was added to my table.

I have Access '97 and FrontPage 2003. I have tried this with FrontPage
creating a database and it still does not save the value of the field in the
database.

So the question is what am I doing wrong? What do I need to do to get it to
work?

Thanks for the help and if you need more information let me know

Thanks
Terry

 

[Thomas A. Rowe]

Suggest that you let FP create the database, as the problem could be with the fact that you are
using Access 97 which you will need to upgrade to Access 2003 to view the database created by
FP2003.

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

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Guest]

Thomas thanks for the information, but as I stated, I told FP to create a new
database and attempted to update it. I then queryed that database and
nothing got stored in it. This is all in web design.

I personally don't see why I should have to upgrade to Access 2003 when I'm
using an Access database. Isn't the core of Access database the same?

Looking forward from hearing back from you.
Terry

 

[Bob Lehmann]

I personally don't see why I should have to upgrade to Access 2003 when
I'm using an Access database. Isn't the core of Access database the same?

Not likely since Access97 is over 7 years old, and until recently Access
upgrades have been historically backwards incompatible.

Like any other old program, how could the 97 version know of the 2003
features? Would you be surprised if PhotoShop2 couldn't use the feature set
of PhotoShop8 ?

Bob Lehmann

 

[Thomas A. Rowe]

The file format of Access 97 is totally different from Access 2000 and Access 2002/2003. If using
FP2003, then it will create a Access 2003 database.

To test your ASP, you must either test it via http://localhost on your PC via your browser or after
publishing to Windows IIS web server via your browser. When data is not written to the database,
that indicates a permission issue or the application root is not set on the web root or subweb /
subsite.

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

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Guest]

Thomas, that is what I do to test the pages. I understand the permissions
issue and I guess that would mean on the directory that it might be read
only. I will have to make sure that the directory and the database are
writeable.

You said "application root is not set on the web root or subweb/subsite."
Can you please expand on this and let me know where this needs to be set and
what it needs to be set to.

Thanks.

 

[Thomas A. Rowe]

Unless you have access to the server as the Admin, you can not set the application root, which set
by open the IIS MMC, then right click on the specific web site, then selecting the Home Directory
tab, and you will the Application setting at the bottom of the dialog.

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

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Mettá]

Just to add to this thread. You can use an Access 97 db in FP2003, but if
you get FP to create the db it will be a later version and not 97
compatible.

To use Access97 db's import the db into the web and away you go.

M

 

[Thomas A. Rowe]

Yes, you can use Access 97, but you will have problem with the database becoming corrupted on a
regular basis.

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

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Clark]

Tom, I have been using FP2000 and Access 2000 and toying with the idea
of upgrading to FP2003

Are you saying that I would need to upgrade to Access 2003 to be sure
things worked if I upgraded to FP2003?

 

[Thomas A. Rowe]

You will only need to upgrade to Access 2003 if you let FP create the database and want to edit it
directly in Access, otherwise there is no problem using a Access 2000 database.

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

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Guest]

Hello Thomas, I hear you about the database becoming corrupted. However, I'm
still having the same issue of the database not getting updated on a local
machine.

I didn't have time to work on it last night, so I figured I would bring it
to the office and load it on my XP machine with Office 2000. I did that and
I created a database in Access with one table and one field. I called the
database test1 and the table name and I think the field name. I then created
a form in FrontPage 2003 and told it to send the result to the database. I
connected the database to the form and made sure that the field in the form
was set to the proper field.

I then ran the form in both Netscape 7 and IE 6.0. After I entered the data
and submitted the form it looked like it ran and then I went to look at the
table and there was no data added. I also allowed FrontPage 2003 to create a
table called test in the proper directory. I ran the form against it and
nothing was added to the table. Here is the kicker, I'm able to update the
scheme in the table from frontpage. I can also update the scheme in Access
97. There are extra fields that can be added to the table and when I do
that, those fields get added to the table, but no DATA gets added to the
table.

I also made sure that the web server from IIS management had write abiltiy
to the site, still nothing was added to the database. There is something
that I'm missing or haven't set correctly and I don't know what it is.

So I know that FrontPage and is communication with the database because it
can update the scheme, but no records/data is added to the tables.

HELP!!!!!!!!!!!

Terry

 

[Thomas A. Rowe]

1. The "Name" can not be used a field name, as it is a reserved word.
2. Is the database being stored in the fpdb folder as a .mdb and is a global.asa file being created?
3. Have you run a check on the extensions for the specific web?
4. Have verified/re-created the database connection under Tools | Site Settings | database?
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Guest]

Ok Thomas, I understand about the reserved word. I did make a new database
and created a database called test and have a table name "make" in it. There
is a field called "make," which is a text field. I also put it in fpdb
directory

The global.asa file is getting created and placed in the root directory of
the web. I have check the database that is verified and has a green check
mark beside it.

This question, "3. Have you run a check on the extensions for the specific
web?" I'm not sure how to answer it, but I have the frontpage server
extension 2002 installed on my local computer.

I will try to install a record first and then try to do this again. I doubt
that will work, but I will see.

Thanks

 

[Guest]

I just wanted to jump in on this conversation...I am having the exact same
problem. I am using an Access 2000 database and Frontpage 2002. My
updating, submitting, and deleting is actually affecting my database.

The submission form works, but does not affect the db. The delete process
works, but ends with an error (can't delete from the table), and the udate
module states there is an UPDATE syntax error. All I did was use the wizard
for the three modules. Any ideas?

 

[Guest]

LostBoy, I here you on this. I came home to do some testing and I eventually
got it to work. I tested it on a NetWare 6.0 server and I couldn't add
anything to the database. So I went back to my normal machine which is the
XP box and went on-line.

I found an article at Microsoft that gave me a clue where to look. I don't
have the link because for some reason my machine just stopped. Won't go into
details. However, it told me about file permission on the database. So I
looked at that and everyone except Users had write access to the database.
So I gave that user Write access to the database and it added the record. I
tried other tables and it seems to work like a champ.

I hope this works for you and I hope that down the road, as I put this on a
web site that supports ASP pages that I can keep it working.

I got another problem, but I will start a new thread on that one.

 

[Guest]

Hey thanks for the advice...I will give it a try here in a minute. This is
my first time using this little message board for support, it took me this
long to find my thread again. I will get back to you Harddrive747.

 

[Guest]

I'd like to jump in as well. My problem is very similar. Was using
FP2k/Access2k, upgraded to FP03 but still Access2K. Imported/opened web
originally created with FP2k, it has many forms. E.g. one form writes to an
MDB (in fpbd) via a process created purely using FP dbWiz etc (no coding on
our part). The db works for retrieving data, so we know the connection is
good. Fill form, submit, all looks perfect, the MDB's last modified date is
consistent with the submit timestamp, but NO data added!

ISP says their FP2002 SE's etc are all up to date, all permissions correct
(quadruple checked by ISP admin)

Somebody said ... rewrite form from scratch in FP03. OK did this, exactly
same result. Not to mention, rewriting everything from scratch = ruinously
expensive.

Please Help

 

[Don]

Ted:
You may want to read this thread:
http://www.frontpagewebmaster.com/m-175524/tm.htm
--
Hope This Helps

Don
=====================
IEEE Degree
MS A+ Certified
StarBand Satellite Internet
FCC Certified Installer
FCC 3rd Class Lic.
Playing with FrontPage 2003 ;-)
My Playground: www.xmas-i-am.com
=====================

| I'd like to jump in as well. My problem is very similar. Was using
| FP2k/Access2k, upgraded to FP03 but still Access2K. Imported/opened web
| originally created with FP2k, it has many forms. E.g. one form writes to
an
| MDB (in fpbd) via a process created purely using FP dbWiz etc (no coding
on
| our part). The db works for retrieving data, so we know the connection is
| good. Fill form, submit, all looks perfect, the MDB's last modified date
is
| consistent with the submit timestamp, but NO data added!
|
| ISP says their FP2002 SE's etc are all up to date, all permissions correct
| (quadruple checked by ISP admin)
|
| Somebody said ... rewrite form from scratch in FP03. OK did this, exactly
| same result. Not to mention, rewriting everything from scratch =
ruinously
| expensive.
|
| Please Help
|
|
| "LostBoy" wrote:
|
| > I just wanted to jump in on this conversation...I am having the exact
same
| > problem. I am using an Access 2000 database and Frontpage 2002. My
| > updating, submitting, and deleting is actually affecting my database.
| >
| > The submission form works, but does not affect the db. The delete
process
| > works, but ends with an error (can't delete from the table), and the
udate
| > module states there is an UPDATE syntax error. All I did was use the
wizard
| > for the three modules. Any ideas?
| >
| >

 

[Guest]

thanks for that, though that entire thread seems to discussing some "error
message" that one or another of them is seeing.

I am not seeing any error messages. In fact that is one of my worries,
since it all appears to work, but nothing is actually appended to the db. I
have tried the suggestion of copying in FP2K _fpclass files, but that does
not appear to help. I am not even sure if i had understood the exact fpclass
file replacement process. Moreover, depending on how far back I look in my
archives of FP03 and FP2k versions of ostensibly the same web, the fpclass
files are different. In some instances the when i changed to older fpclass
files, and saved edits in FP03, it overwrote my newly created "old" files,
with its own new files.

Quite honestly, this is a bit of "dog's breakfast", and I am appalled that
MS could release a bit of kit that can cause this enormous mess. Moreover,
apparently this problem has been reported since at least June, and here we
are many months later, and the best I could find on the MS site is to upgrade
to ASP.NET ... sure.

Since going back to FP2K is difficult due to its incompatibility with 02 SE,
I am inclined to follow the suggestions in one part of the thread … move the
whole thing to Dreamweaver.