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
+---