B
Brad Pears
I have a really bizarre security issue.... We have a customer DB app that
uses a front and back end. The front end points to tables in both the back
end DB as well as pointing to some tables in completely different DB's.
I have a form that uses an SQL select clause as it's recordsource as
follows...
"SELECT * FROM TNLHUsers WHERE [sdtype]="D" ORDER BY [Name];
The forms "Allow Edits" and "Allow Additions" properties are set to "Yes".
If I log on to the DB app as myself, I can go to this form and freely modify
/add data as I am a member of the "Admin" group.
However, another user who needs to be able to access this form to add/change
records can display the form and it's data, but all fields appear to be
locked for editing etc... She can not add nor change any data on the form.
So, thinking there must just be some sort of a security issue, I checked -
only to discover that the user is a member of a group that has read, update
and insert rights to the table. For some reason, she is unable to add/change
any data. To get around the issue for now, I have added her to the admins
group - which has solved the problem.
TO do some further checking, I logged onto our Win2K domain as this user to
make sure that she had the proper system rights to the directory containing
the .mdb file that this particular linked table (TNLHUsers) is pointing to.
I had no problems opening teh .mdb and adding/changing records directly in
the table.
I am stumped. I do not know where to look next. This all works fine in my
devleopment area - but development is local to my machine. I suspect some
kind of systems security issue but not sure. Has anyone seen this issue
before? As I said earlier, I have given her "admin" rights for the time
being in order to be able to do her job.
Any help would be most appreciated...
Thanks,
Brad
uses a front and back end. The front end points to tables in both the back
end DB as well as pointing to some tables in completely different DB's.
I have a form that uses an SQL select clause as it's recordsource as
follows...
"SELECT * FROM TNLHUsers WHERE [sdtype]="D" ORDER BY [Name];
The forms "Allow Edits" and "Allow Additions" properties are set to "Yes".
If I log on to the DB app as myself, I can go to this form and freely modify
/add data as I am a member of the "Admin" group.
However, another user who needs to be able to access this form to add/change
records can display the form and it's data, but all fields appear to be
locked for editing etc... She can not add nor change any data on the form.
So, thinking there must just be some sort of a security issue, I checked -
only to discover that the user is a member of a group that has read, update
and insert rights to the table. For some reason, she is unable to add/change
any data. To get around the issue for now, I have added her to the admins
group - which has solved the problem.
TO do some further checking, I logged onto our Win2K domain as this user to
make sure that she had the proper system rights to the directory containing
the .mdb file that this particular linked table (TNLHUsers) is pointing to.
I had no problems opening teh .mdb and adding/changing records directly in
the table.
I am stumped. I do not know where to look next. This all works fine in my
devleopment area - but development is local to my machine. I suspect some
kind of systems security issue but not sure. Has anyone seen this issue
before? As I said earlier, I have given her "admin" rights for the time
being in order to be able to do her job.
Any help would be most appreciated...
Thanks,
Brad