Re: VARPG and MS Access Db Files

[Jim Langston <jimlangston@xxxxxxxxxxxxxxxx>]

I am fairly familiar with ODBC and how it works.

Any Access database can be accessed using the Access ODBC driver.  Nothing
special required in the file.  Consider the Access Database like an OS/400
file.  And consider ODBC like SQL.  Nothing special required when you create
an AS/400 file to access it with SQL.  Same goes for Access databases and
ODBC.

Now, what you have, then is an Access database and the ODBC driver installed.
Then in any PC program that uses ODBC (Excel is one) you can specify the ODBC
driver that points to your Access file (yeah, you are gonna wanna create an
instance of the ODBC driver pointing to your new Access file or Old Access File)
and get to the data.  Different programs have different methods to get to the
data, but all use SQL commands to talk to the ODBC driver.

Good luck!

Regards,

Jim Langston

"R. O." wrote:
> 
> I am new to VARPG and have a question about using Microsoft Access database
> files with the ODBC Interface part in designing a standalone application.
> The IBM manual says the Microsoft ODBC SDK is should be installed. It also
> doesn't go into any detail about how to go about setting up or saving the
> database in Access. I have also heard that you only need to have MS Access
> installed.  Which is true?
> 
> Also, when designing the tables in Access, is there any special properties
> that need to be in place when it is saved, or is the database saved as you
> would any other database you create with Access?  Once it is created, do you
> then just go ahead and bind the Access table's columns in the VARPG program?
>   As you can tell, I'm a bit confused about the complete process of creating
> this link.  Can anyone help me to get through the fog?  Thanks a bunch!
> 
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
> 
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---