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...

Solved, see note in initial post

We are talking about potentially 100 systems that are completely separate from each other. These groups truly do belong to the System. They have other assignments such as resources and permissions. Groups can have other groups nested within them. An account could be in 10 groups and vice versa...

They would be selecting "GroupName" (a, b, c) from the combo box.

An account can be a member of many groups is why the 4th table is needed.

Thank you for the answer. This database is for an administration team who manages air gapped (collateral) systems in various locations. This is so they can track and manage accounts and privileges. They cannot query AD directly and there is no connectivity whatsoever.

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...

Sorry, I am being a bit vauge here. We have an LMS, but for compliance reasons, we have a lot of PDFs that are digitally signed that need to be recorded (government type forms, contracts and whatnot). It's really more a form store, and we like SharePoint because we can give view rights on the...

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...

I think the only real reason we use access is because there is a bunch of non-certification stuff we create data for an track (change request, tickets, etc) and access is the only way we have to aggregate this info, and we are looking to continue this integration. But the reason I’m am sussing...

So in my case, the CertName and CertPerson are actually foreign keys for those fields. Here is a question I have for you to go along with this: Let’s say there are 20 types of training a person could have. And I was looking to build out a form to display them all. In my mind, there do great...

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 am not sure if I am understand the part about linking the certification name table to the employee table. Wouldn’t it more be an employee table, a certification name table, and an employee/certification date junction table? And if you are saying that for query purposes of who needs what...

Thank you for your reply. I actually made a typo, and used CertDate for the field. I did exactly what you have, this is how it was set up before I got the error - yet sadly the error persists. I should mention that the error is possibly from how I am linking this to my main form. My main form...

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...