[AccessD] ODBC connection to AS400

Hello James,

I did a project a few years ago and I had to connect to a table in an AS400,

What we did was export the data to a file prior to my usage of it.  As I was
the only one using the file, I have no idea whether I kept it locked.

I just thought you may be able to do the same, ie, us a copy of the table

Mark





----- Original Message -----
From: "James Hale" <jhale at houston.rr.com>
To: <AccessD at databaseadvisors.com>
Sent: Thursday, March 06, 2003 4:24 AM
Subject: [AccessD] ODBC connection to AS400


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