See notes after each of your questions. --- Rhett McPeake <[EMAIL PROTECTED]> wrote:
> Have any of you converted an Access database to RBase? Yes > > What steps did you take? Very much the same as Buddy's. In addition, I would recommend that you open the Access Relationships screen, right click and select "Show All". Examine this very carefully, as the database is probably not normalized in some areas. Watch out for "Pivot Tables" - these are actually attached Excel spreadsheets. > Do you have to recreate the forms, reports, and queries in RBase? Unfortunately, yes. Fortunately R:Base is a RAD environment. Queries are just views, so open the query in SQL design mode, and translate the cobbledegook into proper SQL. If you are very lucky, the builder used the MSDE for the back end rather than the JET engine, and the SQL will be proper syntax. > > To transfer the data, did you build the tables in Rbase first then > import the data from access? That's the way to go. I didn't use OBDC, however, as the structures were changed significantly. I unloaded the Access data in comma delimited and imported it. Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
