Link to home
Create AccountLog in
Avatar of Star Gazr1
Star Gazr1Flag for United States of America

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Star Gazr1

ASKER

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?
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
When I go to select the Linked Table Manager it is 'grayed out'
do you have a copy of the 32 bit app?
can you upload a copy of the db?
32 bit MS Office Access ?
32 bit database
Yes. I have a copy of that database.   What do you mean by upload a copy of the database?
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
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.
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
.mdb
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.
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
thanks, i will let you know how I make out.
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.