Ask Your Question

Error accessing data source [closed]

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

johnpd gravatar image

updated 2020-10-11 13:37:09 +0100

Alex Kemp gravatar image

I am receiving the error

"Error accessing data source: '<dbname>' : 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 32-bit.


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-11 13:37:39.450340

2 Answers

Sort by » oldest newest most voted

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

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

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

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?


edit flag offensive delete link more


@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 +0100 )edit

Question Tools

1 follower


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

Seen: 216 times

Last updated: Jul 28 '17