Re: Microsoft Access and ODBC

["Vuong Nguyen" <vuongn1@xxxxxxxxxxx>]

Jerome and others,

I did received this error way back, but I configured the file DSN (via 
Client Access) to point to several AS/400 actual database file, doing the 
queries in the Access database.

I have both Access 97 and Access 2000 on my machine.  In 97, I can view the 
data w/no problem, but I did receive your error when I try to view in 2000.  
I create queries w/in my Access 2000 database based on those AS/400 files 
and it works fine (run the query and return data and store data in a 
temporary tables which I create in an Access 2000 database).

In short, try to run the query to get those data instead of trying to see 
the link file in datasheet view when you work with Access 2000.

Vuong.

>From: Jerome Kinderman <msplus@pacbell.net>
>
>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
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
+---