Changes to Data won't save

G

Guest

I have a webform that posts to an Access Database which is stored on a
network drive. The data that is submitted via the web successfully posts to
the Access Databse.

There are 4 users that review the data submitted and add to it via a form I
created in the same Access Database. They add either "approved", "denied" and
if "denied", they also add data to a "further details" field explaining why
they denied the request. This data is then seen on the web by the user that
originally submitted the request.

I created the Database and when I go in to add my "approval", "denial" and
"further details", the data successfully saves to the database. However, if
anyone else goes in and adds their decision, the data does not save. I assume
this has something to do with the fact that I created the database.

At this point, security is not an issue. I am fine with anyone logging on to
the database having all rights to the database which is what I thought was
set by default. Evidently, it's not. I have looked at the posts here and have
visitied and re-visited Access help multiple times. I cannot figure out how
to resolve this.

Thanks so much for your help!!
 
R

Ron Hinds

It's probably a Window's permissions issue on the folder where the database
file is stored. You have permissions to the folder since you created it, but
no one else does.
 
R

Ron Hinds

What about on the database file itself? Also, are you getting any error
messages?
 
G

Guest

There are no error messages. The other users updates appear to stick but when
you go back in to the database, the changes are gone. Yes, file permissions
are set to R&W from the folder and the file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top