Can't add records to an Access db

[LScal]

Hello,
I have a site that posts - or used to post - to an access db. I've been
round the block with my host and they did admit to finding a write
permissions issue with the folder where the db resides. Unfortunately, if
that's the case, nothing has changed. What I'm finding is that the date/time
stamp is updating each time the form posts, and when I open the table to
enter a record manually the AutoNumber field reflects all the attempts that
have been made at adding a record. For example, the table has 581 actual
records and when I enter a record manually the next record number is 612.
I've looked at everything of mine, but the thing is nothing has changed on
my end. I haven't even touched the db and forms for months.
Any ideas would be greatly appreciated.

 

[Stefan B Rusynko]

After they "fixed" whatever did you check your DB connection
Tools Site Settings Database
And your form properties?
--




| Hello,
| I have a site that posts - or used to post - to an access db. I've been
| round the block with my host and they did admit to finding a write
| permissions issue with the folder where the db resides. Unfortunately, if
| that's the case, nothing has changed. What I'm finding is that the date/time
| stamp is updating each time the form posts, and when I open the table to
| enter a record manually the AutoNumber field reflects all the attempts that
| have been made at adding a record. For example, the table has 581 actual
| records and when I enter a record manually the next record number is 612.
| I've looked at everything of mine, but the thing is nothing has changed on
| my end. I haven't even touched the db and forms for months.
| Any ideas would be greatly appreciated.
|
|

 

[LScal]

Hi -thanks,
Yes, I've checked/verified the db connection and the form properties, and
published again. The behavior is still the same. Is there something I should
ask my host to do, like start over again?
I used to be able to test my stuff with Personal Web Server, but since the
upgrade to XP Home (as I understand it) I no longer have that luxury. Is
that true or is there something available that you know of?

Thanks again,
Lisa

 

[Thomas A. Rowe]

Open the live/remote site in FP and check/verify the database connection.

Windows XP Home does not support any MS web server.

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

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

 

[kmd]

I am having a similar problem where the form is not
posting data to the database. I have a System DSN setup,
the connection tests out fine, the Properties in the IIS
directory specify the application. How do I check to see
that the access database has write priviledges? Any
ideas why this would be happening, would I need to
reinstall the server extensions?

 

[LScal]

You should create a new post - not in the string with an existing one.

I am having a similar problem where the form is not
posting data to the database. I have a System DSN setup,
the connection tests out fine, the Properties in the IIS
directory specify the application. How do I check to see
that the access database has write priviledges? Any
ideas why this would be happening, would I need to
reinstall the server extensions?

-----Original Message-----
After they "fixed" whatever did you check your DB connection
Tools Site Settings Database
And your form properties?
--

_____________________________________________
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
_____________________________________________


| Hello,
| I have a site that posts - or used to post - to an access db. I've been
| round the block with my host and they did admit to finding a write
| permissions issue with the folder where the db resides. Unfortunately, if
| that's the case, nothing has changed. What I'm finding is that the date/time
| stamp is updating each time the form posts, and when I open the table to
| enter a record manually the AutoNumber field reflects all the attempts that
| have been made at adding a record. For example, the table has 581 actual
| records and when I enter a record manually the next record number is 612.
| I've looked at everything of mine, but the thing is nothing has changed on
| my end. I haven't even touched the db and forms for months.
| Any ideas would be greatly appreciated.
|
|


.

 

[LScal]

Thanks Thomas...the web server was wishful thinking on my part. Oh well.
I opened the remote site in FP and verified the db, but the results are
still the same. This shouldn't be that difficult. I've never encountered
these symptoms before. Any other suggestions (other than a can of lighter
fluid) would be appreciated.
Thanks

 

[Thomas A. Rowe]

Ask your host to check the permissions on the folders and the application root setting.

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

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

 

[LScal]

Thanks again.
I've asked my host to do as you suggested. We'll see what kind of response I
get.