Orion and MS Access for Demonstration

[Bernard Briggs]

I've seen two problems that exist with using Orion/EJBs with MS Access.   We're trying to use Access for a small pilot as it is easy to move around.     1)  MS Access or JDBC-ODBC bridge doesn't support the primitive type long   2) MS Access or JDBC-ODBC bridge has a low limit on the size of it's "records"     For the lack of long support, I map longs to ints.   For the size issue, I map String types to char(128) instead of the default char(256)   My question:   Does anyone know of a more "elegant" way to use Access and get around these limitations?  I'd rather not have to tiptoe around these issues in the way described here if there is a better alternative.