I use an Access program in my work environment. I want to link one of my
combo boxes in the Access program to an Excel spreadsheet created by another
department. The Access database is in constant use and I would like to know
what effect this would have on the Excel spreadsheet in terms other
departments ability to make changes to the spreadsheet. ie- if Access is
using the spreadsheet to populate the values of the combo box, can the other
department still make changes to their spreadsheet at anytime??