Hi Ray, > This may be a naive question, but I just could not find the button in OO Base > 2.0.4. > Please accept my apology in case that the solution turns out to be so obvious. > In MS Access, one can achieve the separation of actual data from codes of > queries, forms, etc., by using the feature of linked tables in MS Access. > > MS Access 2003 example: > File - Get External Data - Link Tables > will see an arrow at left of the linked table icon > indicating that it is only a pointer to a table in another file > > The data section of database includes table definition, > table relationship (foreign keys), constraints, triggers, > etc., and the actual data. Let us call it the server part. > > The code section of database includes pointers to actual tables > (in a different *.mdb or *.odb), view definition, query definition, > forms, etc., and **no data**. Let us call it the client part.
Quite funny :) No, no offense intendend :) Actually, up to OpenOffice.org 1.x, Base worked exactly this way: We had only a data source definition, which comprised of forms, reports, queries, and information how to access the data. The data itself layed somewhere else on the hard disc, or on a database server. With OOo 2.0, we moved to database files containing all client part, plus (optionally) the actual data, i.e. the server part. That was a significant change which was done since users, at least those coming from MSA, repeatedly *requested* this kind of self-contained database. No you come and ask for the opposite :) Well, in fact the old way does still work. If you do not use the default database format (embedded HSQLDB), then you'll have the perfect separation of the client from the server part, as already outlined by Anthony. Just put your data onto some database server, or use the dBase format. What you currently cannot do is mixing those two worlds. HSQLDB itselfs supports linking external text files as tables, and can apply its full power - primary keys, relationships, indexes, whatever - to those "external text tables". There's currently no user interface for this, but that's being developed. This will be similar to the "Link Tables" feature you cited from MSA. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
