Hi, OO Base community: alternative subjects: * table links * linked tables * separation of data and code * separation of deployment/upgrade for data and code * server and client sections of database
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. The server and client parts of database are kept in separate files. They are "linked" by the table pointers in the client, the "linked tables". With this separation, revision and deployment of code is much easier. Impact on actual data content is either minimized (hopefully eliminated) or contained as data and code are separated. The scaling of the number of clients (users) is also partially decoupled from the data content. Thanks for help. Ray ________________________________________ PeoplePC Online A better way to Internet http://www.peoplepc.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
