Solved

MS Access shared database

Posted on 2013-05-10
16
310 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
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

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.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

626 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