ODBC--call failed

[Harmony407]

Hello:

Our organization uses MS Access to store all of our members
information.

Our primary database computer is running on Windows 98. This is where
the main database exists. The MS Access version we are running is MS
Access 95, V7. I know it is very old, but the organization is afraid
to update to a newer version for fear of losing data. So, I must work
with what I have.

Previously we had a secondary computer which ran on Windows 95. This
was networked with the Windows 98 computer and a Dell Server.

I have been able to remove the Windows 95 computer and connect the XP
comp. to the network. I can access the primary database on the XP
comp. without a problem. I can make changes to existing tables, forms,
etc. Except for one table.

Every time I try to open this one particular table I get an ODBC--call
failed message.

I tried to re-create the specs in the ODBC control panel with the ones
on the Windows 95 computer. It did not work.

What is the problem? I am new to ODBC and it is baffling to me that
everything in the database works except for the one table!

Thank you for any help you can provide!

Harmony

[Ed Robichaud]

Microsoft has abandoned support for Windows 95 and Access 95; you should do
the same. Access 95 was seldom, if ever, used for developing stable
applications.
I don't know of any professional programmer that would take on the task of
keeping your app in Access95.

Your data, and most of your existing forms/reports/etc. will be successfully
converted when you upgrade to Access 97 (also not MS supported now, but a
reliable product) or preferably to Access XP/2002. $90 retail for the
upgrade product.

I've successfully converted dozens of my own and clients' applications from
Access2 and 95 versions. You'll need to download an interim converter from
MS if you plan to jump from Access95 to something later than Access2000.

More importantly for you, all the newer versions have better ODBC drivers
and setup/control wizards.
-Ed

"Harmony407" <Da**********@gmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

Hello:

Our organization uses MS Access to store all of our members
information.

Our primary database computer is running on Windows 98. This is where
the main database exists. The MS Access version we are running is MS
Access 95, V7. I know it is very old, but the organization is afraid
to update to a newer version for fear of losing data. So, I must work
with what I have.

Previously we had a secondary computer which ran on Windows 95. This
was networked with the Windows 98 computer and a Dell Server.

I have been able to remove the Windows 95 computer and connect the XP
comp. to the network. I can access the primary database on the XP
comp. without a problem. I can make changes to existing tables, forms,
etc. Except for one table.

Every time I try to open this one particular table I get an ODBC--call
failed message.

I tried to re-create the specs in the ODBC control panel with the ones
on the Windows 95 computer. It did not work.

What is the problem? I am new to ODBC and it is baffling to me that
everything in the database works except for the one table!

Thank you for any help you can provide!

Harmony