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

Discuss the database features

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

Postby sgilewicz » Wed Sep 12, 2018 10:45 pm

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
Last edited by Hagar Delest on Thu Sep 13, 2018 9:27 pm, edited 1 time in total.
Reason: tagged solved
Open Office 4.1.5
Windows 10 Pro 64 Bit
sgilewicz
 
Posts: 3
Joined: Wed Sep 12, 2018 10:24 pm

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

Postby RoryOF » Wed Sep 12, 2018 10:48 pm

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.
Apache OpenOffice 4.1.5 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 27182
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Postby sgilewicz » Wed Sep 12, 2018 10:59 pm

Thanks for the quick reply. Where does the underlying db engine typically reside and what would be its name? Sorry for the ignorance!
Open Office 4.1.5
Windows 10 Pro 64 Bit
sgilewicz
 
Posts: 3
Joined: Wed Sep 12, 2018 10:24 pm

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

Postby Villeroy » Thu Sep 13, 2018 11:01 am

The status bar of the Base window indicates the database connection.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25703
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

Postby sgilewicz » Thu Sep 13, 2018 1:26 pm

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!
Open Office 4.1.5
Windows 10 Pro 64 Bit
sgilewicz
 
Posts: 3
Joined: Wed Sep 12, 2018 10:24 pm

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

Postby Villeroy » Thu Sep 13, 2018 1:47 pm

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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25703
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Base

Who is online

Users browsing this forum: No registered users and 4 guests