2. ASPRunnerPro General questions
  3. Security Issue - list view won't filter - as per security settings
This topic is locked

Security Issue - list view won't filter - as per security settings

 		3/26/2008 6:18:40 PM
ASPRunnerPro General questions
T
 tlitts13 author

ASPRunner v5.1 build 327

DB - Access 2000
I'm trying to set the security (limit view/editability) of a table to only those

records that a specific user has added. I believe that I have followed instruction correctly but......
Here is what I have:
In the owner (login table) I have users (username, groupid, password, and id (autonumber - primary key - type long integer)).

In the main table i have a field usrid (type long integer).
I set up a relationship in the security - advanced settings as specified for "users can see edit their own data only" - owner table field (id) main table field (usrid)
Once I build and add some data, the "list" edit and view buttons are available for all data, for each user - regardless of the user and not limited to only the data a specific user entered as expected.
Of note: the correct id (owner table) is written to usrid (main table) when data is entered. Just not filtering properly?
I'm probably missing something obviouse. Any help is appreciated.
Thanks
J
 		Jane 3/27/2008

Hi,
it's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.
T
 		tlitts13 author 3/27/2008

Hi,

it's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.


Jane I was able to figure it out this morning. I had, accidentally, in the group settings given my user group admin privileges. I new it had to be something obvious. Thanks.