Access Help - Adding comments to a linked table

[satori_1]

Hi,

I hope somebody can help as i have been looking on the net for an
answer for days :-(

I have a access database that links into a SQL system that performs
reviews on my users access levels to different IT systems... IE if you
have domain admin access on AD then its listed in the database that
you have it.. there are also another 28 systems and it covers 30,000
users....

The SQL database automaticly sends review emails to the owners of the
systems to check that the users should have this level of access.. the
person then completes the review and the row in the table thats
relevent to the persons access has a field that changes to Valid,
Leaver or Remove.

I get supplied a linked table to that SQL database with the following
info

Username, Login , System, first name, second name, status

All as headers to the table....

I then filter that table using access to show me all the people with
the status not Valid....

What i then want to do is link comments to these rows so when i
contact the person who did the review i can find out why they are not
valid and put that in the comments box....

However i cant work out how to do this. New people are added to the
main lists all the time so i cant link it by name... also people have
the same name... I cant add the comments to the Table itself as its a
linked table and therefor you cant edit it...

What i need is a way to dump the linked table into another table so
that i can add the comments colum on the end.. or another way... but
im totally stuck..

any help?

 

[Albert D. Kallal]

Would not be username plus logon plus system named the unique key you can
use here?

when I build a continuous form that displays all the information you have
based on a query, that joins in your local table that you don't modify from
each time and each week, and you place the comments in that table. back
table will be joined by a query into your fresh data and you join on the
three fields.

I'm reasonably sure that the query likely is not going to be updateable
(but, give it a try). You can solve this problem by simply placing a placing
a little button on the continuous form that launches your comments box. That
comment edit box would launch, and check if the comment record exists, and
if yes, then edit/display, or simply add a new record, and then
edit/display.

You could probably also put a big text box on the bottom of the screen or
right side, and as you navigate the comments would display for each record
in that box (I think my first suggestion is a little easier though). Both of
these approaches would display the comments and you move through the records
anyway.

Of what I mean by repeating buttons that you click on to get additional
details, this is a common UI, and here is some screen shots of what I
mean...

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

 

[satori_1]

Would not be username plus logon plus system named the unique key you can
use here?

when I build a continuous form that displays all the information you have
based on a query, that joins in your local table that you don't modify from
each time and each week, and you place the comments in that table. back
table will be joined by a query into your fresh data and you join on the
three fields.

I'm reasonably sure that the query likely is not going to be updateable
(but, give it a try). You can solve this problem by simply placing a placing
a little button on the continuous form that launches your comments box. That
comment edit box would launch, and check if the comment record exists, and
if yes, then edit/display, or simply add a new record, and then
edit/display.

You could probably also put a big text box on the bottom of the screen or
right side, and as you navigate the comments would display for each record
in that box (I think my first suggestion is a little easier though). Both of
these approaches would display the comments and you move through the records
anyway.

Of what I mean by repeating buttons that you click on to get additional
details, this is a common UI, and here is some screen shots of what I
mean...

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

i think this is what i have done.. the problem is that the table that
contains comments has to have a unique id that matches a unique id in
the linked table... otherwise they cant pair up?

because the login username and systems are added and changed all the
time ... i cant make sure they are always in my commetns list to match
up.. without exporting the linked list into my comments list manually
every time???

I dont know any other way of doing it other than having a matched
field in both tables that i do a join on :-(

 

[satori_1]

i think this is what i have done.. the problem is that the table that
contains comments has to have a unique id that matches a unique id in
the linked table... otherwise they cant pair up?

because the login username and systems are added and changed all the
time ... i cant make sure they are always in my commetns list to match
up.. without exporting the linked list into my comments list manually
every time???

I dont know any other way of doing it other than having a matched
field in both tables that i do a join on :-(- Hide quoted text -

- Show quoted text -

Any Help????