Excel Validation to Access Table

[dcavaiani]

Is this possible in Office 2002? Can I create a dropdown selection/validation in Excel - which accesses/uses/is populated by a table in Access ??

 

[Rx_]

Sure. Now, the question back to you is can it be done in a Macro-Free workbook?
Do you know how to make the drop-down part of a Named Range?
Do you know how to make a Link from a Named Range to a query on a linked table?

It was around 2003 when I did that for many users application.
Is this a one user application or something dozens of people would use?

If a Macro enabled Workbook is possible, it would probably be easier.
But, macro enabled workbooks has its overhead for distribution too.