Change the path of a linked spreadsheet (1 Viewer)

R

rplohocky

Registered User.

Local time

Yesterday, 20:33

Joined

Apr 13, 2017

Messages

45

• Apr 24, 2017

• #1

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?

 

pbaldy

Wino Moderator

Staff member

Local time

Yesterday, 18:33

Joined

Aug 30, 2003

Messages

36,125

• Apr 24, 2017

• #2

Right click on any table in the Navigation pane and choose the Linked Table Manager. Select the linked spreadsheet, "Always Prompt for new location" and Ok.

 

R

rplohocky

Registered User.

Local time

Yesterday, 20:33

Joined

Apr 13, 2017

Messages

45

• Apr 24, 2017

• #3

pbaldy said:

Right click on any table in the Navigation pane and choose the Linked Table Manager. Select the linked spreadsheet, "Always Prompt for new location" and Ok.

Click to expand...

Yea, I tried that but I get a pop up saying "the wizard you requested is not installed or is in a bad state. Please install or reinstall the wizard."

 

isladogs

MVP / VIP

Local time

Today, 02:33

Joined

Jan 14, 2017

Messages

18,216

• Apr 24, 2017

• #4

Can happen after an error
Close & reopen Access
If necessary do a compact & repair

 

R

rplohocky

Registered User.

Local time

Yesterday, 20:33

Joined

Apr 13, 2017

Messages

45

• Apr 24, 2017

• #5

ridders said:

Can happen after an error
Close & reopen Access
If necessary do a compact & repair

Click to expand...

Thanks but still no go. I clicked on the compact & repair but it doesn't seem to do anything. I am very new at Access just so you know.

 

isladogs

MVP / VIP

Local time

Today, 02:33

Joined

Jan 14, 2017

Messages

18,216

• Apr 24, 2017

• #6

Try a Google search for the exact phrase you wrote in post 3
For example,

http://softlabpro.blogspot.co.uk/2013/04/ms-access-wizard-isnt-installed-or-has.html

However, you might want to try restarting windows / repairing Office before trying anything drastic. The problem has always fixed itself for me

 

J

JamesStewart250

New member

Local time

Yesterday, 18:33

Joined

May 23, 2017

Messages

1

• May 23, 2017

• #7

rplohocky said:

Thanks but still no go. I clicked on the compact & repair but it doesn't seem to do anything. I am very new at Access just so you know.

Click to expand...

If "Compact and Repair" utility will not work for you, then try a third party solution, like Kernel for Access database recovery software. It will defiantly help you.