I think it is possible. I have an access program that uses idata. You
define the data field in the access database as a "linked odbc" table. At
least that's how I did it and it works. I can get you more information if
you need it... Define the table(s) as Linked odbc...I hope this makes
sense. I was only linking my customer master. I did end up redefining my
customer master because if I recall, I couldn't have any fields in it with #
signs or something like that. Stupid and weird...but I made it a linked
odbc table
George
(712) 579-5444 (cell)
985 Oak Rd
Harlan, IA 51537
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
dlclark@xxxxxxxxxxxxxxxx
Sent: Monday, March 12, 2018 2:32 PM
To: Midrange Systems Technical Discussion
Subject: Re: MS Access Database
"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 03/12/2018
03:23:40 PM:
"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 03/12/2018
02:55:31 PM:
I have a request to create an MS Access Database file from data on
the i. I haven't been able to find any articles on how to do this,
so I assume it's not possible. But, I thought I would go the extra
mile and post a forum question. I know that MS Access can import
files and convert them, but that is not what is requested. The
Engineer wants a MDB file that can be read by the production machine.
We are currently at 7.2.
I am writing from the IBM i to MS SQL Server using JDBC. So,
if
MS Access supports JDBC then it can be done.
Found this free solution:
http://ucanaccess.sourceforge.net/site.html
Sincerely,
Dave Clark
--
int.ext: 91078
direct: (937) 531-6378
home: (937) 751-3300
Winsupply Group Services
3110 Kettering Boulevard
Dayton, Ohio 45439 USA
(937) 294-5331
****************************************************************************
*****************
This email message and any attachments is for use only by the named
addressee(s) and may contain confidential, privileged and/or proprietary
information. If you have received this message in error, please immediately
notify the sender and delete and destroy the message and all copies. All
unauthorized direct or indirect use or disclosure of this message is
strictly prohibited. No right to confidentiality or privilege is waived or
lost by any error in transmission.
****************************************************************************
*****************
--
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:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
