HI .
Greetings!
I have synced a SP list to Access DB, and I assign user permissions of the SP list directly on SharePoint List Permission Admin page.
Right now I want to directly retrieve the current user info of the SharePoint List from Access DB , including my own logging username , email ect. when my Access DB is online with the SharePoint List. Please Note:
1. The Access DB is originally synced from Company SharePoint List from company intranet, not other way around.
2. I have used Currentwebusers (X), but returns empty value.
3. I have used Currentusers and returned as admin, this username has nothing to do with SP List.
4. I have used Environ Function, and returned the computername, username and my domain of the company intranet , but not exactely like the user info list synced from the SP list , for instance, the SP User List showing my full name, but the environ function return only my signature.
5. I have full rights of the SP list.
6. I can see my full name showing in the Access DB Records as created by , and modified by. I just need retrieve this information and it will be very useful to set query criteria etc.
I have tried A lot, Please help you if you know how to do it :banghead:
Greetings!
I have synced a SP list to Access DB, and I assign user permissions of the SP list directly on SharePoint List Permission Admin page.
Right now I want to directly retrieve the current user info of the SharePoint List from Access DB , including my own logging username , email ect. when my Access DB is online with the SharePoint List. Please Note:
1. The Access DB is originally synced from Company SharePoint List from company intranet, not other way around.
2. I have used Currentwebusers (X), but returns empty value.
3. I have used Currentusers and returned as admin, this username has nothing to do with SP List.
4. I have used Environ Function, and returned the computername, username and my domain of the company intranet , but not exactely like the user info list synced from the SP list , for instance, the SP User List showing my full name, but the environ function return only my signature.
5. I have full rights of the SP list.
6. I can see my full name showing in the Access DB Records as created by , and modified by. I just need retrieve this information and it will be very useful to set query criteria etc.
I have tried A lot, Please help you if you know how to do it :banghead:
