Re: Download directly to a Access db file

["Joep Beckeringh" <joep@xxxxxxxxxxxxxxxxxxx>]

Mike,

Access stores all its data in one .mdb file, in a way that is presumably
only known by Microsoft.  FTP-ing straight into this file is asking for
trouble.  What you have to do is either export from the AS/400 in a format
that Access can import, or use ODBC, so Access can get at the AS/400 data
itself.

Joep Beckeringh


----- Original Message -----
From: "mike wrogg" <mwrogg@yahoo.com>
To: <RPG400-L@midrange.com>
Sent: Wednesday, August 30, 2000 7:00 PM
Subject: Download directly to a Access db file


> Hello,
>
> I'm using FTP to transfer a AS/400 database file to a
> PC access database file.  When I FTP it to the access
> database file it seems to work Okay.  However, when I
> try and open the access database file it give me the
> following error message,  unrecognized database
> format.
>
> I believe it's because my not converting from Hex to
> ASCII format.  If this is the reason is there an easy
> way to do the conversion before I FTP the file?
>
> Thanks,
> Mike Wrogg



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