I created a test Database in Access. I then converted it to a database that Open Office base can read. (odb). I then successfully created a report. I used the wizards.
Now I want to use an updated Access database file, convert it to the ODB form and Then run the same query and report. I only see how to rebuild the query and report.
Using same report for updated database
Using same report for updated database
Open Office 4 On PC Windows 10
Re: Using same report for updated database
[Tutorial] MS Access and OOo Base
I have no idea how you "converted" the database. Does the status bar look like this?
![Image](https://forum.openoffice.org/en/forum/download/file.php?id=30380)
If not, which type of connection is indicated in the status bar.
I have no idea how you "converted" the database. Does the status bar look like this?
If not, which type of connection is indicated in the status bar.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Using same report for updated database
Hi
I converted the database by using the information from Web.. Says
Launch Open Office Base
Choose connect to an existing database cjppse <ocrpspft Access
Choose the database
Register the database & Open the database0 for editing
Finally Save the database
Bottom status bar says Microsoft Access
I converted the database by using the information from Web.. Says
Launch Open Office Base
Choose connect to an existing database cjppse <ocrpspft Access
Choose the database
Register the database & Open the database0 for editing
Finally Save the database
Bottom status bar says Microsoft Access
Open Office 4 On PC Windows 10
-
- Volunteer
- Posts: 1549
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: Using same report for updated database
Anytime changes have been made to the Access fileI want to use an updated Access database file
On the main Base window select Tables
then from the menu select View>Refresh Tables.
What has changed? Just the data, or have you modified the table fields/columns?
If only the data has changed then your queries and reports should work without modification.
If the table structure has changed, then you will probably need to Edit of replace the queries and reports.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Re: Using same report for updated database
Your Base document is linked to (not converted from) the JET datwabase which is embedded in the Access document which is fine.
The last step of the report wizard offers a choice to create
a) a static report
b) a dynamic report
You want "dynamic" which is preselected by default. If you choose "static", your report shows a snapshot of current data.
Another reason I can think of:: if you have the database loaded in MS Access while testing your Base report, it may be that Base can not see the latest data because they are not yet stored to the database. Close MS Access and try again.
The last step of the report wizard offers a choice to create
a) a static report
b) a dynamic report
You want "dynamic" which is preselected by default. If you choose "static", your report shows a snapshot of current data.
Another reason I can think of:: if you have the database loaded in MS Access while testing your Base report, it may be that Base can not see the latest data because they are not yet stored to the database. Close MS Access and try again.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice