Search results

Hi all, I built an access application that distributes itself over a file share, and checks for updates from the OG location on the file share. This issue is that I am running into trust center issues where the first time the new databases are opened the AutoExec macro can’t run and it’s...

Hi. I have the following basic structure: A System table with SystemID and SystemName; A Groups table with GroupID, SystemID (FK), and GroupName; An Accounts table with AccountID, SystemID (FK), and AccountUsername; An AccountGroups table with AccountGroupID, GroupID, and AccountID. I have a...

I am trying to model some Active Directory account stuff in MS access. I have an “Accounts” table, but I am finding it hard to mode a “user account” vs a “service account”. Is the best way to do it just keep it all in the same accounts table? Or do I need to make stemmed tables? I can’t see...

Hi I have a linked list from SharePoint that uses people picker. In SharePoint, I can add anyone in my org, but in MS access, I can only add people that are already a member of the site or have been previously used in the list. Is there any way to get all people in my org added so I can use...

Hi. My company requires a bunch of annual compliance training. I want to integrate it into our account tracking database but I know access can’t handle the files (I’m talking upwards of 800 documents a year). We are thinking about using sharepoint lists (among other reasons) to store it but...

I have a list called TrainingCerts with fields ID, CertName, PersonName, Date, and Attachment.FileURL. This is a linked list from sharepoint lists. There are about 10 different certifications each due every year, lets call them cert1, cert2, etc. So, my list is pretty big (about 800 people...