Solved

MS Access shared database

Posted on 2013-05-10
16
303 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
  • 9
  • 7
16 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero 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 119

Assisted Solution

by:Rey Obrero
Rey Obrero 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
 
LVL 3

Author Comment

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

Expert Comment

by:Rey Obrero
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 119

Expert Comment

by:Rey Obrero
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 119

Assisted Solution

by:Rey Obrero
Rey Obrero 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 119

Assisted Solution

by:Rey Obrero
Rey Obrero 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 119

Assisted Solution

by:Rey Obrero
Rey Obrero 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
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.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

757 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now