At 09:56 AM 8/9/2004 +1200, Frank van der Zwaag wrote:
Can you use MS-Access to connect to an Rbase database and query/add/modify the data?
Frank,
Yes, you can!
Make sure that you have established a System DSN for R:BASE 7.x database using the R:BASE 7.x ODBC driver or Oterro 3.0.
I tried doing that using odbc but can't get past the tables. I.e. can see the tables but can't link.
Make sure that your database CHARacter SETtings are SQL/ODBC compliant, i.e:
DELIMIT , LINEEND ^ SEMI ; QUOTES ' PLUS + SINGLE _ MANY % IDQUOTES `
Do I need to use Oterro by any chance?
You don't have to. But Oterro 3.0 is the preferred way to share R:BASE 7.x database with "other" DBMS or front end applications.
http://www.rbase.com/products/oterro
Very Best R:egards,
Razzak.
