Excel Userform with data validation from Access DB

[padadof2]

I am trying to make a userform that we can use to import information that is in a worksheet named "Index" as well as other information to into our access Database. When we get a new project, we then take the owners name and information, the Contractors name and information and put into our database. We don't have any data validation, so there are multiple entries for the same owner, so I would like to have a dropdown list in the userform from the DB, so I can see if I need to add a new owner or if that owner already exists. I'm not sure if its even possible. right now I have a worksheet in my network with the owners we already have, but its not dynamic when I add another owner. Thanks in Advance

 

[padadof2]

Still looking for some direction if anyone can help. Thank you