I have a spreadsheet that gets its data from Access. The problem i ran into today is that if i move the spreadsheet and DB to a different drive/PC, all connections are lost. I do not want to manually update each and every connection when i distribute it to another user or pc. Is there a way of modifying the SQL statement "FROM" so that it will always look for the DB in the same directory as the spreadsheet?
Here is the current SQL "FROM" statement:
FROM E:SPMNETOM_Collected_Access`.ICPHO2 ICPHO2
This would be a tremendous time saver as well as headache cure.
Thanks,
Waxaholic
Here is the current SQL "FROM" statement:
FROM E:SPMNETOM_Collected_Access`.ICPHO2 ICPHO2
This would be a tremendous time saver as well as headache cure.
Thanks,
Waxaholic