Page 1 of 1

[Solved] How to copy a Base db to another PC?

Posted: Wed Sep 12, 2018 10:45 pm
by sgilewicz
Hello all!

I am new to Open Office Base but have worked, for many years, with Access and SQL Server. My problem is trying to copy a small Base db (that helps my local HOA track tennis members, courts and matches) to my HOA's PC. After copying the odb file to the HOA PC I can launch the "new" db but when I try to access any content (tables, forms, etc) I get the following:

The connection to the data source "Mens Tennis" could not be established
The URL 'file:///C:/Users/stan/Documents/Mens%Tennis' is not valid. A connection can not be created.

After numerous hours of scouring the internet for an explanation I have humbly come here seeking enlightenment! I have copied Access files from one PC to another many times (provided it was not a shared db). It goes without saying that I am probably missing a simple item or concept. FYI the odb file has been registered with the correct path and I have tried placing it in both user and new directories with the same result. Any help with what seemed to be a simple process is greatly appreciated!

Stan

Re: How to copy a Base db to another PC?

Posted: Wed Sep 12, 2018 10:48 pm
by RoryOF
The .odb file is merely a front end to an underling database engine. You need to move that also, then set the link, as the error message tells you.

Re: How to copy a Base db to another PC?

Posted: Wed Sep 12, 2018 10:59 pm
by sgilewicz
Thanks for the quick reply. Where does the underlying db engine typically reside and what would be its name? Sorry for the ignorance!

Re: How to copy a Base db to another PC?

Posted: Thu Sep 13, 2018 11:01 am
by Villeroy
The status bar of the Base window indicates the database connection.

Re: How to copy a Base db to another PC?

Posted: Thu Sep 13, 2018 1:26 pm
by sgilewicz
Thanks! I got it transferred successfully. I was completely clueless that the db files were not part of the odb file. Your help is much appreciated. Great forum!

Re: How to copy a Base db to another PC?

Posted: Thu Sep 13, 2018 1:47 pm
by Villeroy
sgilewicz wrote:Thanks! I got it transferred successfully. I was completely clueless that the db files were not part of the odb file. Your help is much appreciated. Great forum!
Sometimes they are. The statusbar reads "HSQLDB embedded" then. This embedded type may be called a "Base database". Yours is obviously not a "Base database".
The actual type of database is the most important info when dealing with Base questions.
Base is not a database. Base is a tool to work with databases.