[AccessD] ODBC connection to AS400

Gave a look through here maybe in the IBM redbook links
http://search400.techtarget.com/home/0,,sid3,00.html

James Hale wrote:

>Using the IBM client Access ODBC driver I have links to tables residing on
>the AS400. If I open these tables to view the AS400 gives me exclusive use
>of the file. The problem is it never releases the table for use by others
>until I quit Access. Does anyone know how to release the table? Similarly,
>if someone has use of the table and I try to open it I get an ODBC
>connection failed error. What is the correct way to trap for this error? TIA
>Jim Hale
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>