We help IT Professionals succeed at work.

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

Medium Priority
347 Views
Last Modified: 2013-12-03
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?
Comment
Watch Question

Commented:
Hi wbstech,

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

Dave :-)

Commented:
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
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

Author

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.

Commented:
Anything new been installed?
What is the other datasource?
How are you connecting to it?
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.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.