[AccessD] Rbase

Jim,

This makes me feel much better about the 2-hour round trip to get the
data.  Using Rbase's tools at their site was definitely the way to go,
once I went there.


Thanks,

Liz 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
JHicks at lincoln.ne.gov
Sent: Monday, April 24, 2006 4:46 PM
To: Access Developers discussion and problem solving
Cc: accessd at databaseadvisors.com; accessd-bounces at databaseadvisors.com
Subject: Re: [AccessD] Rbase


Don't bother with the ODBC drivers.  If my memory is correct, they don't
always work very well.  We have converted almost all of our RBase 4.5 to
Access 2000 (over 50 applications for some 200 RBase databases).  The
process we use is to export each RBase table to DBF files, then import
those into Access.  Your client's RBase has all the necessary tools
(i.e.
Gateway) to do the export from RBase.  One gotcha is that whoever set up
the RBase tables may have used some dBase reserved words as part of the
table or column names.  Column  names will also be truncated at eight
characters.  If so, you can issue the RENAME COLUMN command at a R>
prompt to change those.

If you have any questions, feel free to contact me off list.

Jim Hicks
Systems Analyst Programmer II
City of Lincoln
Information Services
402-441-7199