Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

MS Access shared database

Posted on 2013-05-10
16
Medium Priority
?
322 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 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 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 2000 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
Independent Software Vendors: 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 2000 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 2000 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 2000 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

Independent Software Vendors: 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!

Question has a verified solution.

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

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
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.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

581 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