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

x
?
Solved

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

Posted on 2006-03-22
8
Medium Priority
?
325 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?
0
Comment
Question by:wbstech
  • 3
  • 2
6 Comments
 
LVL 34

Expert Comment

by:flavo
ID: 16256081
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
 
LVL 34

Expert Comment

by:flavo
ID: 16256085
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
 
LVL 7

Expert Comment

by:IT-Schubertz
ID: 16256090
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 4

Author Comment

by:wbstech
ID: 16256168
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
 
LVL 34

Expert Comment

by:flavo
ID: 16256198
Anything new been installed?
What is the other datasource?
How are you connecting to it?
0
 
LVL 4

Accepted Solution

by:
wbstech earned 0 total points
ID: 16256536
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

571 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