Solved

MS Access shared database

Posted on 2013-05-10
16
308 Views
Last Modified: 2013-05-10
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.
0
Comment
Question by:fjkaykr11
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 9
  • 7
16 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 39156341
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
 
LVL 3

Author Comment

by:fjkaykr11
ID: 39156393
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
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 500 total points
ID: 39156444
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 3

Author Comment

by:fjkaykr11
ID: 39156505
When I go to select the Linked Table Manager it is 'grayed out'
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39156532
do you have a copy of the 32 bit app?
can you upload a copy of the db?
0
 
LVL 3

Author Comment

by:fjkaykr11
ID: 39156589
32 bit MS Office Access ?
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39156669
32 bit database
0
 
LVL 3

Author Comment

by:fjkaykr11
ID: 39156769
Yes. I have a copy of that database.   What do you mean by upload a copy of the database?
0
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 500 total points
ID: 39156818
try that copy of the db.
hold the shift key while opening it and try the steps i posted above.
0
 
LVL 3

Author Comment

by:fjkaykr11
ID: 39156828
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
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 500 total points
ID: 39156871
what is the file extension of the database file you are using?
0
 
LVL 3

Author Comment

by:fjkaykr11
ID: 39156933
.mdb
0
 
LVL 3

Author Comment

by:fjkaykr11
ID: 39157072
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
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 500 total points
ID: 39157087
<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
 
LVL 3

Author Comment

by:fjkaykr11
ID: 39157102
thanks, i will let you know how I make out.
0
 
LVL 3

Author Closing Comment

by:fjkaykr11
ID: 39157384
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

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question