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