ODBC--call failed - Microsoft Access / VBA

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

Nov 13 '05 #1

Subscribe Reply

2412

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**********@g mail.com> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.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

Nov 13 '05 #2

Similar topics

2640

Exception Login failed for user '(null)'

by: mo | last post by:

The code I've pasted below is taken directly from Microsoft's site at http://support.microsoft.com/default.aspx?scid=kb;EN-US;308157 As far as I can tell the error is raised on this line: conn = New SqlConnection("server=MyServer;Integrated Security=SSPI;database=pubs") If I use the code as is, I get the error above. The code only works if I hardcode the username and pwd into it as in the following line:

.NET Framework

2088

Failed to Start Monitoring Directory Changes

by: Jeff Reed | last post by:

I am experiencing the the problem outlined the below. Unfortunately, I am using WinXP and I not sure if I can apply the solution due to lack of security control Any feed back would be apreciated http://support.microsoft.com/default.aspx?scid=kb;EN-US;31795 FIX: "Failed to Start Monitoring Directory Changes" Error Message When You Browse to an ASP.NET Pag View products that this article applies to This article was previously...

ASP.NET

3198

Error: Failed to start monitoring changes - Framework 1.1

by: Tim D | last post by:

Hi, I originally posted this as a reply to a rather old thread in dotnet.framework.general and didn't get any response. I thought it might be more relevant here; anyone got any ideas? My questions are below... "David Good" wrote: > We have a network running both Win2k and Win2k3 webservers and our web sites > reside on a UNC network share that happens to be a Network Appliance NAS.

ASP.NET

2742

Detecting Failed Authorization

by: Bijoy Naick | last post by:

I've implemented forms authentication and authorization on my application. In my Web.Config, my authorization section looks like this.. <authorization> <allow roles="admin" /> <deny users="*" /> </authorization> If an authenticated user, who is NOT designated the role "admin" attempts to access this folder, he/she is simply redirected to the login page.

ASP.NET

1005

Failed to map the path '/App_GlobalResources/'

by: Adam | last post by:

Trying to get an asp.net 2.0 app running and am receiving this error. I see a bunch of people with this error on the net, but no solution: Works fine on my local machine, deployed to a server it yields this message. Failed to map the path '/App_GlobalResources/' Stack trace: at System.Web.Hosting.HostingEnvironment.MapPathActual(VirtualPath virtualPath, Boolean permitNull)

ASP.NET

2682

open of /usr/lib/pgsql/data/pg_clog/0F3E failed

by: ruben | last post by:

Hi: I'm running a large database on PostgreSQL 7.1.3. 20 days ago the database failed with a threatening and not too descriptive error like: pg_exec() query failed: server closed the connection unexpectedlyThis probably means the server terminated abnormally before or while processing the request. I lost some data and had to recreate a table, without knowing the reason

PostgreSQL Database

11983

error LNK2022: metadata operation failed

by: Laurent Lequenne | last post by:

Hello There, I just converted a VS 2003 C++ Project into VS 2005. I already made some changes in my headers files, has I had compilations errors with enums declarations. Now everything compiles and I got errors at the link as shown below. If anyone could help me to get that thing compiled, he's welcome :-))) Thanks,

.NET Framework

7695

PHP on command line issues: Function registration failed - duplicate name

by: news | last post by:

I just upgraded to PHP 4.4.2 on my Slackware 10.2 system. And Apache/mySQL/PHP all work great through a browser. No errors. But when I try to run a PHP script through the command line, which I need to do, I get blocks of errors like: root@slackserve:/var/www/htdocs# php ./phptest.php PHP Warning: Unknown(): Unable to load dynamic library '/usr/lib/php/extensions/mysql.so' - libmysqlclient.so.14: cannot open shared object file: No such...

PHP

9753

A connection attempt failed problem

by: Dennis | last post by:

I'm getting the following problem occasionally...the application will work perfectly well for a period of time and then this pops up. I have tried turning off the default proxy in the web.config which I had seen on other posts but that did not solve the problem. Any assistance or ideas would be appreciated Thanks

ASP.NET

4690

failed to open stream problem

by: kencana | last post by:

Hi all, I was wondering why I always get "failed to open stream: HTTP request failed!" error in either loading a normal or xml file. i don't understand why i can't get the whole result. the result i get is only some part of the respective url (the one i tried to load). The following is my php code to open the file: $file=...

PHP

8466

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8384

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8901

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8591

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

5683

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4208

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4388

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2037

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1791

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General