RE: Write in tables from access

Pete,

Regarding the speed, I'm sure there's much to what you say. However, the PC has a heck of a lot to do with it. My boss wrote an Access/VB procedure that I use nightly for sales reporting. It was a real hog (took 5-10 minutes, but not enough time for a smoke break). We got new PC's a couple of month's ago and now I can't even get out of my office before it's through.

Jerry C. Adams
IBM System i Programmer/Analyst
B&W Wholesale
office: 615-995-7024
email: jerry@xxxxxxxxxxxxxxx


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Pete Helgren
Sent: Wednesday, September 03, 2008 1:21 PM
To: Midrange Systems Technical Discussion
Subject: Re: Write in tables from access

You could just link the tables in Access to the tables on the i using
ODBC. I haven't used Access in ages and it used to be a slow process
but I am guessing things are probably a bit more snappy these days.

Pete

Support Mwbrands wrote:

Hello,
How can I configure ODBC driver of iSeries to write in AS400 tables directly
from Access.

I know it's possible to do it from iSeries Navigator. but how from Access?


Thanks,
Marco

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.