Recent content by BrainstormUK

Thanks Isaac, something else to try.

Nice idea Sonic8 will try that out Thanks for all the help.. I was just looking into the 'Hidden' UserInfo list which is automatically added into my linked table

Aha something to try - but currently don't know

Hi Sonic, I think you misunderstand. Access is linked fine to with Owner permissions to SharePoint. Access then allows users to Add Edit Delete etc by making forms read only or whatever depending on the login of the user

Hi George - fully agree wouldn't dream of having the data in OneDrive, I was just thinking that the user details might be in some way in One Drive or perhaps I could put some sort of file to validate against so that then the app can decide if the can edit/add new/etc the data shown in the forms...

I have an MS Access system that grabs the username off the company network to allow user privilege access - CreateObject("WScript.Network").UserName . All data is stored in SharePoint Lists so that users can access the system when not in the office. My problem is, how can I check a user's...

Hi, I have a 2010 form with a navigation control on it with a few tabs. on open I set the navigationbutton.navigationwhereclause to a value on the form that opens the form. The first navigation tab/form doesn't seem to use the nav where clause - if I click on another tab, that form is fine, and...

Too true and thanks... just finding it hard to consider users in the database but there being no ldb... However I think I may have found the reason in that the users of another application, it appears, update their applications from the tables in this database but not by linking but by using...

Why check permissions of those perportedly in the database? If they were in the database would not there be an .ldb file?

I have an Access 2003 database that is kept on a network drive which is used by a process to export the data to another directory. When I try to delete it to put a new version there it says there's a sharing violation and it's being used by other users... but it isn't open - no .ldb file. I go...