Can't add records to an Access db

L

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.
 
S

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.
|
|
 
L

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
 
T

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.
==============================================
 
K

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?
 
L

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
 
T

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.
==============================================
 
L

LScal

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