Apache OpenOffice Community Forum

I am a newcomer to Base. I recently wrote an application for a friend who has MS and it has been working fine. There's a problem however. As he uses it he needs more features added. But in order to do that I have to be physically working on it at his computer. I have found that if I copy the file from one computer to another, the buttons on the forms cease to work because the script can't be found. Also he lives miles away and it would be much better if I could separate the data tables from the forms and queries in different files.

Base can access and write to tables in other database files but not ones created in its own format! Seems amazing to me. I know that it is a single user package currently, but even with that restriction, why isn't there an option, when creating a new database, to connect with another Base data source ie a file that contains only tables?

If there is a way to do this I would appreciate some help.

Thanks

Peter

I have found that if I copy the file from one computer to another, the buttons on the forms cease to work because the script can't be found. Also he lives miles away and it would be much better if I could separate the data tables from the forms and queries in different files.

If Macros stored in one machine My Macros >standard, needs to copy into another machine, same place. If macros stored in Form document it will be transfered during copy.

Base can access and write to tables in other database files but not ones created in its own format! Seems amazing to me. I know that it is a single user package currently, but even with that restriction, why isn't there an option, when creating a new database, to connect with another Base data source ie a file that contains only tables?

It's not fully as you described. Base files are two types, one with embedded database, second type connection to outside database engine, with only one connection. Base file not consist database engine, and zipped all database tables and data. When base open file, extract content into memory, and start HSQL database engine, when close pack it back.

No easy way to connect Base file from outside world, only
with Java: http://digiassn.blogspot.com/2006/07/ja ... on-to.html