Ask Your Question
0

Error accessing data source

asked 2017-07-27 23:02:27 +0200

johnpd gravatar image

I am receiving the error

"Error accessing data source: '<dbname>' : com.sun.star.container. NoSuchElementException: <dbname>"

when attempting to do a "Data" > "Refresh Range" on a Calc spreadsheet containing data pulled from the LO .odb base file. Any idea as to what could be the problem. I am using LibreOffice 5.3.4.2 32-bit.

JohnD

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2017-07-28 00:11:59 +0200

Ratslinger gravatar image

This is most likely due to the Base file being renamed or moved from its originally registered location.

Data Sources in Calc will continue to display the originally registered source but won't be able to locate the actual data.

To fix, from menu Tools->Options->LibreOffice Base->Databases. Click on the problem DB, click Edit button and select new location.

edit flag offensive delete link more
0

answered 2017-07-28 01:26:19 +0200

johnpd gravatar image

Thanks for your reply. I eventually ran across that fix. The files were e-mailed to me. I put them in a folder I defined. When I looked at the database sources for the Calc file, the only thing that was listed was a bibliography database. When I added my database file through the Tools Options, everything worked. I am not sure where it registers the database. If I re-downloaded the Calc file from the e-mail to a different folder and checked the DB sources again, it now shows the proper database file?

JohnD

edit flag offensive delete link more

Comments

@johnpd Please do not use answer for a reply. Use a comment under the appropriate answer (can be multiple answers).

Database registration takes place at time of the Base file creation or using the method as posted in my answer. Other modules (calc, writer, etc.) can then access the data from any properly registered DB. As you've seen, changes in Base file location (and only Base location) affect it.

If this answers your question please click on the ✔ (upper left area of my answer).

Ratslinger gravatar imageRatslinger ( 2017-07-28 01:41:47 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-07-27 23:02:27 +0200

Seen: 135 times

Last updated: Jul 28 '17