I have spent hours trying to find out how to change the path to a spreadsheet that I have linked with a DB in access 2010. Either its impossible or no one has ever had this problem.
I used the DB wizard to create a new DB. I chose to link the DB to my excel spreadsheet in My Documents folder. Now that its done I need to save it to a jump drive and move it to another PC. I am trying to figure out where, if possible, I can change the path to the spreadsheet so my linked DB sees it on the new PC.
Any ideas?
I used the DB wizard to create a new DB. I chose to link the DB to my excel spreadsheet in My Documents folder. Now that its done I need to save it to a jump drive and move it to another PC. I am trying to figure out where, if possible, I can change the path to the spreadsheet so my linked DB sees it on the new PC.
Any ideas?