Software

Ask something
Discussion Locked

MS Access Developers Edition

0 helpful
3 replies

by murphyl

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Help. I need a simple, straightforward, in English answer please. I need to reprogram applications (to distribute)from RPG language (IBM mid-range AS400) to MS Access. I'm really confused. What is the relationship between Access, SQL, Jet, MSDE, VB?How do they interact with one another? Where do I begin? Thanks!

3 replies

by tjc

Access is a database format that the information is stored in.

SQL utilizes a "function" Called Jet to retreive the data information stored in the access database.

VB - visual Basic is a programming language Like RPG. That you could use as a front end program to create the sql statements that utilize the Jet access that reads the access database that inturns gets displayed in your VB program.

You dont' really have to use VB, MS Access has it's own built in macros and such that you can use it all, once it is in access format.

The trick is how to convert your database from the AS400 to Access... You could do it though text files using VB or you can import into access, depending on what you need ofcourse.

This discussion is closed to new replies.