Offer an option to use relative paths for linked tables
At present Access looks for linked tables based on their exact path e.g. 'C:\myDropbox\Data' A lot of us use services like Dropbox where the path structure is the same but the root folder name may have changed e.g. 'D:\myDropbox\Data'. Why not build into access an option to use relative rather than absolute path? If you set that option, Access would use the database folder as the root and search for the linked tables relative to that position. That would simplify delivering databases with frontend and backends for clients as well as managing our databases on multiple PC using Dropbox or similar accounts.
Andy Rice commented
That is a great idea!