R
Ray
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??
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??