Submitted record is not added to Access table

[Tom]

Experts,

I created an htm and asp sample file that -- when working properly -- would
send a record (last name, first name, address, etc.) from the browser into
an Access database.

Since my ISP doesn't support Access and ASP, I created the testing site on
my localhost machine. I'm relatively confident that the setup is ok (well,
one never know...)

Here is the process that I'm seeing when attempting to add a record:
============================================

1. I get confirmation page of the entered values in the form... great

2. I browse to folder (C:\Inetpub\wwwroot\fpdb) that stores the database.
The mdb's date time stamp reflects that the database was "changed" let's say
a minute ago... great

3. I open up the mdb's table but do not find any record in the table... and
that's the problem.

Now, here's what I have done now:

4. On c-drive, in the properties tab for folder "fpdb", I set the following:

Sharing tab:
- sharing this folder on the network - check
- allow network users to change my files - check

Websharing tab:
- share this folder - selected
- alias "dbtest"
- edited access permissions to: Read, write, script source access, directory
browsing
- edited application permissions to: Excecute (includes scripts)

Then I uploaded the fpdb folder to my local host.

Still, when submitting the records in the browser, the date time stamp
changes to the last update. However, the record(s) still does not get
added to the table.

Any idea as to why I don't update my database?

Tom

 

[Stefan B Rusynko]

When working in localhost do not edit the web folders in the localhost file based system locations in windows explorer
Make a copy of the .mdb file outside of your FP web
(or File Export it to your say your desktop from localhost)
In http://localhost in FP use Tools Site Settings Database and delete any connection there
(along w/ any global.asa and fpdb folder you have in your root web)
Now File Import the .mdb and allow FP to create the fpdb folder and its permissions (and the global.asa file)
Check it using Tools Site Settings Database Verify





| Experts,
|
| I created an htm and asp sample file that -- when working properly -- would
| send a record (last name, first name, address, etc.) from the browser into
| an Access database.
|
| Since my ISP doesn't support Access and ASP, I created the testing site on
| my localhost machine. I'm relatively confident that the setup is ok (well,
| one never know...)
|
| Here is the process that I'm seeing when attempting to add a record:
| ============================================
|
| 1. I get confirmation page of the entered values in the form... great
|
| 2. I browse to folder (C:\Inetpub\wwwroot\fpdb) that stores the database.
| The mdb's date time stamp reflects that the database was "changed" let's say
| a minute ago... great
|
| 3. I open up the mdb's table but do not find any record in the table... and
| that's the problem.
|
| Now, here's what I have done now:
|
| 4. On c-drive, in the properties tab for folder "fpdb", I set the following:
|
| Sharing tab:
| - sharing this folder on the network - check
| - allow network users to change my files - check
|
| Websharing tab:
| - share this folder - selected
| - alias "dbtest"
| - edited access permissions to: Read, write, script source access, directory
| browsing
| - edited application permissions to: Excecute (includes scripts)
|
| Then I uploaded the fpdb folder to my local host.
|
| Still, when submitting the records in the browser, the date time stamp
| changes to the last update. However, the record(s) still does not get
| added to the table.
|
| Any idea as to why I don't update my database?
|
| Tom
|
|

 

[Tom]

Stefan:

Thanks for the feedback... here's what I have done... still unsuccessful.

- deleted the fpdb folder and global.asa on local host
- attempted to delete any connection in Tools Site Settings... there weren't
any (probably since I already deleted the fpdb folder)
- in FrontPage, highlight folder fpdb and file global.asa and clicked
"Publish selected files..." ... which put both folder and file onto the
localhost

Still, no records are added when clicking SUBMIT. You mentioned that I
should do a "File Import of the .mdb"... is "publishing selected files" the
same?

This is really frustrating me... particularly since I see that some
connection to the mdb was made based on the updated date time stamp.

Any final thoughts?

Tom

 

[Tom]

Stefan:

Maybe I need to reconsider saying that the date time stamp is updated. The
files shows the latest DTS equal to the time when creating a connection.

It doesn't appear that SUBMIT actually changes the DTS.

Here's what I noticed when going through your steps yet another time.

- on pc, I opened the folder "fpdb"
- I went through the steps to IMPORT the file
- during the import process, I'm prompted to enter a connection name
- when I navigate 1 level up (all folder incl. fpdb and files such as
global.as) I notice that
global.as is prefixed with a "question mark icon"
- once I publish the global.as file from pc to localhost I am asked a 2nd
time to enter the connection name. I choose the same connection but then I
"told" that this connection already exists, so I select NO.

Is this why? How then would I import the mdb to the localhost directly vs.
import it to pc and then upload to localhost.

 

[Stefan B Rusynko]

Do not publish anything from "pc" to local host (or even open a disc based web in FP)

My steps again
Open Only your Server based site in FP (File Open Site http://localhost) under the FP SE
In http://localhost in FP use Tools Site Settings Database and delete any connections there
(along w/ any global.asa and fpdb folder you have in your root web)
Run a Tools Recalculate Hyperlinks
Now in the server based web (http://localhost) select your root and use File Import (browse to the .mdb file on your PC)
- and allow FP to create the fpdb folder and its permissions, put the .mdb file in the fpdb folder (plus create the correct
global.asa file), - yes enter a DB connection name when asked
Check the DB connection using Tools Site Settings Database Verify

Then in your asp page (or DBRW page) use the new DB connection (by name) and the tables named in it

(again none of which will work on your online server since they don't support Access and ASP, so don't even try to publish it
there)




| Stefan:
|
| Maybe I need to reconsider saying that the date time stamp is updated. The
| files shows the latest DTS equal to the time when creating a connection.
|
| It doesn't appear that SUBMIT actually changes the DTS.
|
| Here's what I noticed when going through your steps yet another time.
|
| - on pc, I opened the folder "fpdb"
| - I went through the steps to IMPORT the file
| - during the import process, I'm prompted to enter a connection name
| - when I navigate 1 level up (all folder incl. fpdb and files such as
| global.as) I notice that
| global.as is prefixed with a "question mark icon"
| - once I publish the global.as file from pc to localhost I am asked a 2nd
| time to enter the connection name. I choose the same connection but then I
| "told" that this connection already exists, so I select NO.
|
| Is this why? How then would I import the mdb to the localhost directly vs.
| import it to pc and then upload to localhost.
|
| --
| Thanks,
| Tom
|
|
| | > When working in localhost do not edit the web folders in the localhost
| > file based system locations in windows explorer
| > Make a copy of the .mdb file outside of your FP web
| > (or File Export it to your say your desktop from localhost)
| > In http://localhost in FP use Tools Site Settings Database and delete any
| > connection there
| > (along w/ any global.asa and fpdb folder you have in your root web)
| > Now File Import the .mdb and allow FP to create the fpdb folder and its
| > permissions (and the global.asa file)
| > Check it using Tools Site Settings Database Verify
| >
| >
| > --
| >
| > _____________________________________________
| > 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.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | > | Experts,
| > |
| > | I created an htm and asp sample file that -- when working properly --
| > would
| > | send a record (last name, first name, address, etc.) from the browser
| > into
| > | an Access database.
| > |
| > | Since my ISP doesn't support Access and ASP, I created the testing site
| > on
| > | my localhost machine. I'm relatively confident that the setup is ok
| > (well,
| > | one never know...)
| > |
| > | Here is the process that I'm seeing when attempting to add a record:
| > | ============================================
| > |
| > | 1. I get confirmation page of the entered values in the form... great
| > |
| > | 2. I browse to folder (C:\Inetpub\wwwroot\fpdb) that stores the
| > database.
| > | The mdb's date time stamp reflects that the database was "changed" let's
| > say
| > | a minute ago... great
| > |
| > | 3. I open up the mdb's table but do not find any record in the table...
| > and
| > | that's the problem.
| > |
| > | Now, here's what I have done now:
| > |
| > | 4. On c-drive, in the properties tab for folder "fpdb", I set the
| > following:
| > |
| > | Sharing tab:
| > | - sharing this folder on the network - check
| > | - allow network users to change my files - check
| > |
| > | Websharing tab:
| > | - share this folder - selected
| > | - alias "dbtest"
| > | - edited access permissions to: Read, write, script source access,
| > directory
| > | browsing
| > | - edited application permissions to: Excecute (includes scripts)
| > |
| > | Then I uploaded the fpdb folder to my local host.
| > |
| > | Still, when submitting the records in the browser, the date time stamp
| > | changes to the last update. However, the record(s) still does not get
| > | added to the table.
| > |
| > | Any idea as to why I don't update my database?
| > |
| > | Tom
| > |
| > |
| >
| >
|
|