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.