RE: Microsoft Access and ODBC

["Bale, Dan" <DBale@xxxxxxxx>]

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