MS Access shared database

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

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

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

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?

ASKER

32 bit MS Office Access ?

32 bit database

ASKER

Yes. I have a copy of that database. What do you mean by upload a copy of the database?

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

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

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

.mdb

ASKER

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

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

thanks, i will let you know how I make out.