MS Access shared database

I upgraded from XP that had MS Access 2010 to  Windows 7 with MS Access 2010.  When I try to run an existing query it can't find the path to the shared database on a network drive. Any ideas on how to fix?   Thanks.
LVL 3
fjkaykr11Asked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
open the db while holding the Shift Key and right click on any linked table and select Linked table Manager

check the box Always prompt for new location

click on Select All

click OK

locate the path to the shared database


click ok
0
 
fjkaykr11Author Commented:
thanks for the info.   one other item,  the old version of Office was 32 bit and the new version of office is 64-bit.   Would this matter?
0
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
you can upgrade your 32 bit app to 64 bit app, but anything you create on that will not be accessible to 32 bit app.

i would not advice this unless it is a must.

see this links for more info
http://office.microsoft.com/en-us/word-help/choose-the-32-bit-or-64-bit-version-of-office-HA010369476.aspx


http://msdn.microsoft.com/en-us/library/office/ee691831.aspx
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
fjkaykr11Author Commented:
When I go to select the Linked Table Manager it is 'grayed out'
0
 
Rey Obrero (Capricorn1)Commented:
do you have a copy of the 32 bit app?
can you upload a copy of the db?
0
 
fjkaykr11Author Commented:
32 bit MS Office Access ?
0
 
Rey Obrero (Capricorn1)Commented:
32 bit database
0
 
fjkaykr11Author Commented:
Yes. I have a copy of that database.   What do you mean by upload a copy of the database?
0
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
try that copy of the db.
hold the shift key while opening it and try the steps i posted above.
0
 
fjkaykr11Author Commented:
that is the database I am trying to do this with.  The Linked Table Manager option is grayed out.  I don't know how I can select that.
0
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
what is the file extension of the database file you are using?
0
 
fjkaykr11Author Commented:
.mdb
0
 
fjkaykr11Author Commented:
I think I might have found the issue (not sure).  This is working ok on another computer running Windows 7 64-bit but they have Office 2010 (32 Bit).  The computer having the issue opening the database is running Office 2010 (64-bit) -- the Application that the MS Access is linked to has a 32 bit ODBC driver.   Any way to set the MS-Access to operate in 32-bit mode?  Or do I need to downgrade to MS office 32-bit?  Thanks.
0
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
<Or do I need to downgrade to MS office 32-bit?> yes, uninstall the 64 bit and install the 32 bit

i would prefer using the MS office 32-bit
0
 
fjkaykr11Author Commented:
thanks, i will let you know how I make out.
0
 
fjkaykr11Author Commented:
It's going to be a while before I test so I am going to close out and award points. Thanks for sticking this out.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.