We have four MS Access databases that are used almost on a daily basis. Each database contains records that are input and maintained by members of the staff. The person who updated the items are listed in a field on each database. The names of staff members change frequently because of people leaving the job or people being hired.
There is an official excel spreadsheet list that is kept on a shared drive and is updated frequently by the administrative staff.
I have decided that I want all of our databases to pull the staff members' names from the excel list and not depend on local lists created for each table in the databases. I would like to have pull downs in each db on the field that holds the names and allow the users to select from that current list since it is always up-to-date.
My problem is that Access will not allow me to use the Excel spreadsheet to supply the names because it wants to use a list from an Access table.
Is it possible to create an Access combo box which will pull the names from the Excel spreadsheet column? We are using Access version 2007 in Windows.