Re: Microsoft Access and ODBC

The problem with MS Access 2000 has to do with the new Jet Engine 4.0 that
is included with it.

You need to update your MDAC files to make Access 2000 Jet Engine compatible
with the Client Access ODBC driver. You can download the update at
www.microsoft.com/data.

I am using the new 2.5 version of MDAC and it is working fairly well.

Shadrach Scott


----- Original Message -----
From: "Angela Wawrzaszek(EXCH)" <wawrzaszeka@AUSTEEL.com>
To: <MIDRANGE-L@midrange.com>
Sent: Thursday, June 01, 2000 1:28 PM
Subject: RE: Microsoft Access and ODBC


> I also have been unable to use access 2000 to link or import a file.  I am
> getting the same error.  I have tried re-installing it, changing the query
> time out...  So far nothing.  So if you do find a solution PLEASE let me
> know!
>
>
> Angie Wawrzaszek
> M.I.S. Department
>
>
> -----Original Message-----
> From: Jerome Kinderman [mailto:msplus@pacbell.net]
> Sent: Wednesday, May 31, 2000 5:53 PM
> To: MIDRANGE-L@midrange.com
> Subject: RE: Microsoft Access and ODBC
>
>
> I am using Access 2000.  I created a File DSN using Client Access's Data
> Source Administration.  I am able to select the file I want to link to on
> the AS400 as well as view and select the key fields in those files.  The
> error is on the Microsoft Access side: "Reserved Error (-7778); there is
no
> message for this error"  and "Access cannot open the table in datasheet
> view."  Nor can it open it in any other view.  I attempted to create a
form
> to view the data there, but I receive the same error.  Any help would be
> appreciated.
>
> Jerry Kinderman
> Lodi, California
>
> -----Original Message-----
> From: owner-midrange-l@midrange.com
> [mailto:owner-midrange-l@midrange.com]On Behalf Of Bale, Dan
> Sent: Wednesday, May 31, 2000 10:19 AM
> To: 'MIDRANGE-L@midrange.com'
> Subject: RE: Microsoft Access and ODBC
>
>
> What specific error message are you getting?  What version of Access are
you
> using?  Which ODBC?
>
> I am unclear on where the error is popping up.  Are you getting an AS/400
> signon window?  Are you seeing a list of file names available from your
> library list to be imported?
>
> We were getting an error where we would select the AS/400 file and click
> Import; after about 5-10 seconds, an error window would appear, something
> about a "file unavailable" or somesuch, even though the file was not at
all
> allocated on the AS/400.  Our fix was to reinstall Access.
>
> I highly doubt that the drive letter issue is a problem.
>
> hth,
> Dan Bale
>
> > -----Original Message-----
> > From: Jerome Kinderman [SMTP:msplus@pacbell.net]
> > Sent: Wednesday, May 31, 2000 11:44 AM
> > To: MIDRANGE-L@midrange.com
> > Subject: Microsoft Access and ODBC
> >
> > Has anyone encountered any problems using Microsoft Access via ODBC on
the
> > AS/400?  I have configured the file DSN (via Client Access) to point to
an
> > AS/400 database file which was created via Query.  Everything seems to
> > work
> > fine when attempting to display the new table in Access (after all other
> > steps are successful), I receive an error on the Microsoft Access side
> > that
> > indicates that the file cannot be viewed.  Now I am aware that Microsoft
> > Access (and most other Windows/DOS applications) really like to have
their
> > files accessed via a drive letter (e.g., c:\) and ODBC does not follow
> > this
> > model.  If anyone has any suggestions regarding this (including, "Call
> > Microsoft") I would appreciate it.
> >
> > Jerry Kinderman
> > Lodi, California
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---
>

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---