× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



This is just something that I heard but I thought Microsoft had changed
Access to use the SQL Server engine underneath so it would be like using
SQL Server for reliability.

If that were true, you might be able to access with the same drivers as SQL
Server.

On Mon, Mar 12, 2018 at 3:01 PM, D*B <dieter.bender@xxxxxxxxxxxx> wrote:

hopefully correct list (I'm tired and going to bed!)

--------------------------------------------------
From: "D*B" <dieter.bender@xxxxxxxxxxxx>
Sent: Monday, March 12, 2018 10:55 PM
To: "RPG programming on the IBM i / System i" <rpg400-l@xxxxxxxxxxxx>
Subject: Re:MS Access Database

Hi Kent,

For the first part SQuirreL would be my recommendation (it's open Source
and available at Sourceforge). You would need an additional JDBC Driver,
but this would be no problem for running it at a windows box. For the
second part (accessing MS Access from the AS/400) ArdGate could do this
(it's open source too). I f you find a Java type 4 JDBC driver (UCAN access
myight be possible), you could run ArdGate all on AS/400 and access MS
Access with embedded SQL in RPG, or any other SQL interface (STRSQL, QM
Query or even Query400). If you want/must use a Windows only JDBC driver,
ArdGate is possible too; installing the java part on a windows box, the
native part on AS400 it would work as mentioned before.

Feel free to ask additional questions.

Dieter

<Kent>
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.
</Kent>


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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.