Deb, Oterro is what you would use when you want some other programming environment to manipulate data in an R:BASE database. If you want R:BASE to be the programming tools you use with an outside data source, you need the ODBC driver for that other data source. Your system may already have an ODBC driver for MS Access.
Go into Control Panel/Administrative Tools/Data Sources and click on the Drivers tab. You may find a "Microsoft Access Driver" on the list. If not, you would have to get one from a place like Microsoft.com. Set up your Data Source so that R:BASE can see it by clicking on the "System DSN" tab, then choosing "New". Pick the Microsoft Access Driver, then fill in the blanks and browse to the MDB file that contains the Access database. After you do all that, then the R:BASE SCONNECT (or, from the menus, Utilities/Connect SQL Data Source) should get you started. There are often little problems in connections between one ODBC driver and a different environment, caused by different data type characteristics and different naming conventions. If you hit any of the problems, come back here and somebody will have a solution. Bill Deb Roepken wrote: > > Hi- > > I'm happy to say my customer is delighted with the product I designed > for them and have asked me to look into connecting to an outside data > source (Access), or perhaps a complete conversion may be involved. I've > purchased Oterro 3 and started with the readme text and I assume ( and I > don't like to assume) I have to start with SConnect. Who can I talk to > about this? > > *Deb Roepken > * * CMR, Inc. > * *631-587-1495 > * > > >
