Continuing Access2K/Informix problems...

Continuing Access2K/Informix problems...

Post by Jesse Yarbroug » Sun, 31 Dec 1899 09:00:00



Original Problem:

I am trying to connect Access2000 to my Informix Database. The DSN is
created successfully, the link to the tables is made successfully, I can
view the design of the tables, I just can't view the data - getting the
error: 'Microsoft Access can't open the table in Datasheet view.'. I am
using the informix driver: Informix-CLI 2.5 (32-Bit). Any ideas? Thanks.
? Thanks.

Quote:>> try updating MDAC from Microsoft

This seemed to work for about 24 hours. But I am not sure if I downloaded
the correct file. I downloaded mdac_typ.exe from microsoft. It seemed to be
the most current version all rolled into one and on top of the list. Right
now, if I run mdac_typ.exe everytime I open Access 2000 it works for about
an hour. We are running Informix 7.1 STI. I am also on NT4.0 Wks/Srv Pack 6.
Please post all messages to the newsgroup. Thank you,  

Jesse

 
 
 

Continuing Access2K/Informix problems...

Post by Watawino » Sun, 31 Dec 1899 09:00:00


>ubject: Continuing Access2K/Informix problems...

>Date: 18.03.00 02:46 W. Europe Standard Time

>Original Problem:


>I am trying to connect Access2000 to my Informix Database. The DSN is
>created successfully, the link to the tables is made successfully, I can
>view the design of the tables, I just can't view the data - getting the
>error: 'Microsoft Access can't open the table in Datasheet view.'. I am
>using the informix driver: Informix-CLI 2.5 (32-Bit). Any ideas? Thanks.
>? Thanks.

>>> try updating MDAC from Microsoft

>This seemed to work for about 24 hours. But I am not sure if I downloaded
>the correct file. I downloaded mdac_typ.exe from microsoft. It seemed to be
>the most current version all rolled into one and on top of the list. Right
>now, if I run mdac_typ.exe everytime I open Access 2000 it works for about
>an hour. We are running Informix 7.1 STI. I am also on NT4.0 Wks/Srv Pack 6.
>Please post all messages to the newsgroup. Thank you,  

>Jesse

You have a lot of version problems:

Informix 7.1 is obsolete.
CLI 2.5 is obsolete.

Install Informix7.3 or 9.2.
Install Client SDK 2.4x or Informix Connect

Nona

 
 
 

1. Importing Access2K Table to another Access2K Database

Hi All

I want to copy tables from an Access2K DB to another Access DB for Backup
purposes

Is there a VB6 equivalent of Access 2K's Import function or do I have to
create the new tables then copy the data across?

Regards
Steve

2. can't start ODBC bridge

3. Setup cannot continue...Setup cannot continue...

4. *** US-FL-Boca Raton- UNIX, C, Oracle Systems Analyst ***

5. To continue or not to continue

6. Replicating from foxpro

7. problems with explain plan in 9i EE for linux

8. Continued Fields in Informix-4gl?

9. Problem with trapping errors (access2k+sql2k)

10. SQL/Access2K Filtering problems