Access 2000 - 'Cannot find installable ISAM' - Also many options like 'Linked Table Manager' are grayed out

Within an Access database, which was thought to be working up until today, I am now getting an error message when tying to open a report: "Cannot find installable ISAM".

I assumed this might be down to some missing ODBC links required for some of the data needed to be retrieved for this report; But sadly when I go to Tools, many options are grayed out, in particular the 'Linked Table Manager', 'Upsizing Wizard', and so on.

What could this be down to?
LVL 4
wbstechAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

flavoCommented:
Hi wbstech,

Is this on a  PC that worked yesterday?  Could be a driver issue.  What datasource are you connecing via ODBC to?

Dave :-)
0
flavoCommented:
For the drivers:
How to obtain the latest service pack for the Microsoft Jet 4.0 Database Engine
http://support.microsoft.com/kb/239114
Dave
0
IT-SchubertzCommented:
Hi,

this sounds like you did some Update or SP to this PC. Maybe the Jet engine got corrupted by this.

How to obtain the latest service pack for the Microsoft Jet 4.0 Database
Engine
http://support.microsoft.com/kb/239114

Install it and try again.
One common mistake that causes this message are wrong connection strings. e.g. if you write DataSource instead of Data Source (but that doesn't seem the problem here.

hth

Andy
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

wbstechAuthor Commented:
Update:

It doesn't work on the majority of machines on our network (All Win2K machines) - But a select few, it does work on.

They all have the same version of Access on.

I also just tried updating Jet on my machine, which didn't solve it.
0
flavoCommented:
Anything new been installed?
What is the other datasource?
How are you connecting to it?
0
wbstechAuthor Commented:
Ok the problem has been solved - It was the fact that some people had a desktop link to an old version of the database. Absolutely no idea why this is the case though.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Fonts Typography

From novice to tech pro — start learning today.