I have created links from Excel to Access to allow data to update automatically (yes, I have to use Excel for my "reports" because this is what our customers only know how to use). One of the tables which is created is a list of color options, which you can see below.
The problem is that, as you can see, we also will then discontinue a particular color. But when Excel goes to refresh the table which is linked . . .
I get the following error:
The same error takes place if I attempt to add a color to the list we offer.
Is there some way to link the data, but write code that allows for the insertion of rows/deletion of rows if the size of the table changes?
Thanks!!