I used access since 97. Trying to switch to Unbuntu Liebreoffice and I made a simple testdb. I set up Ucanaccess to open it’s table only backend 2007(accdb). I mostly use the gui with some sql and VB. They usually consist of forms with a subform linked with a master and slave field. The subform never filters based on the main form. As I switch records in the main form the subform just shows all the records in the table control.
FrmMain “tblWOD”
“ID” Int Autovalue with Primary key
“date” Date/Time [TIMESTAMP]
“description” text[VARCHAR]
“notes” text[VARCHAR]
“Warmup” Text[VARCHAR]
“WODName” Text[VARCHAR]
“WODSyle” Text[VARCHAR]
“BestResult” Text[VARCHAR]
Subform “tblWOD” link master WODName slave WODName
Table control fields
ID,date,WODName,description,BestResult
I have also setup it up by transferring the database backend to MySQL and connecting with MariaDB JDBC and it works fine.
The reason for the testdb is because I would like to also use this driver to link to a large mdb (tables only) backend where I also use mainly forms and subforms to show the data but when I set it up the subforms they won’t filter either. It too, works with MySQL and MariaDB JDBC. I have set up onetomany relationships for the large mde because I have 8 different tables linked by an ID number but not the testdb (only one table). I also wrote the testdb in HSQLDB Embedded and everything works fine so I don’t think I’ve done anything wrong in the form linking.
Could I get pointed in some direction because I been working on this for days.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Really don't know how to do that and wouldn't know what I was looking for. But! what you are saying is, it should work. I'll keep working on it.
Thanks for the quick answer and if I find the problem I'll make a donation to the cause.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Really don't know how to do that and wouldn't know what I was looking for.
But! what you are saying is, it should work. I'll keep working on it.
Thanks for the quick answer and if I find the problem I'll make a donation
to the cause.
Thanks Marco. I'll give it a go for a week or so to see if I can find the problem first. Helps to know it should work. I used the deugger a little in access VB so I'll look into setting one up for LO also.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Really, I have tried everything, I can think of, to get this to work.
I have used ucanaccess to open large db with tables in a one-to-many. I have also tried for smaller db with no relationships. I used both Libreoffice and Openoffice. Both in Win10 and Ubuntu.
None work with sub-forms. The sub-form is never filtered on the link for master and slave.
The access db is the backend (tables only). Ucanaccess will import the relationships if there is any but they still will not work with form/subform. I have tried to use From Design with the Form Navigator and also the Form Wizard.
The one I uploaded only has one small tbl with the one form. I would just drop it and move on but isn't this is what a connector is for?
There are no calls with error on UCanAccess, all work fine there. Please send along another odb linked to HSQLDB and the form working as expected.
The error seems to be outside our scope.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Nein dear, I needed something else: the form working. You said it works if you link it to an hsqldb so I needed an Odb that doesn't point to access but to an hsqldb and with the form working as expected.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I used access since 97. Trying to switch to Unbuntu Liebreoffice and I made a simple testdb. I set up Ucanaccess to open it’s table only backend 2007(accdb). I mostly use the gui with some sql and VB. They usually consist of forms with a subform linked with a master and slave field. The subform never filters based on the main form. As I switch records in the main form the subform just shows all the records in the table control.
FrmMain “tblWOD”
“ID” Int Autovalue with Primary key
“date” Date/Time [TIMESTAMP]
“description” text[VARCHAR]
“notes” text[VARCHAR]
“Warmup” Text[VARCHAR]
“WODName” Text[VARCHAR]
“WODSyle” Text[VARCHAR]
“BestResult” Text[VARCHAR]
Subform “tblWOD” link master WODName slave WODName
Table control fields
ID,date,WODName,description,BestResult
I have also setup it up by transferring the database backend to MySQL and connecting with MariaDB JDBC and it works fine.
The reason for the testdb is because I would like to also use this driver to link to a large mdb (tables only) backend where I also use mainly forms and subforms to show the data but when I set it up the subforms they won’t filter either. It too, works with MySQL and MariaDB JDBC. I have set up onetomany relationships for the large mde because I have 8 different tables linked by an ID number but not the testdb (only one table). I also wrote the testdb in HSQLDB Embedded and everything works fine so I don’t think I’ve done anything wrong in the form linking.
Could I get pointed in some direction because I been working on this for days.
You should download UCanAccess code and enable remote debuging from LO so that you could figure out what doesn't work.
Really don't know how to do that and wouldn't know what I was looking for. But! what you are saying is, it should work. I'll keep working on it.
Thanks for the quick answer and if I find the problem I'll make a donation to the cause.
Try to give us something simple to reproduce the problem. If I have an
instant I'll give a look into.
Il Sab 9 Gen 2021, 20:51 Randy ranc505@users.sourceforge.net ha scritto:
Thanks Marco. I'll give it a go for a week or so to see if I can find the problem first. Helps to know it should work. I used the deugger a little in access VB so I'll look into setting one up for LO also.
Really, I have tried everything, I can think of, to get this to work.
I have used ucanaccess to open large db with tables in a one-to-many. I have also tried for smaller db with no relationships. I used both Libreoffice and Openoffice. Both in Win10 and Ubuntu.
None work with sub-forms. The sub-form is never filtered on the link for master and slave.
The access db is the backend (tables only). Ucanaccess will import the relationships if there is any but they still will not work with form/subform. I have tried to use From Design with the Form Navigator and also the Form Wizard.
The one I uploaded only has one small tbl with the one form. I would just drop it and move on but isn't this is what a connector is for?
ok, now I can take a look, I'll let you know my findings
Firstly your LO configuration is wrong : even if it won't solve your problem, please follow the suggestions in this article
https://askubuntu.com/questions/187389/is-it-possible-to-open-an-access-2010-database-file-without-using-wine-or-virtua/519571
This is closer. It lists the depend
http://tahsinabrar.com/open-a-microsoft-access-accdb-file-in-ubuntu/
It's totally wrong and could cause harm!
I'll change it and try again.
Thank you I have fixed the jar file loading error. But I'm still left with the problem of the frm subfrm.
There are no calls with error on UCanAccess, all work fine there. Please send along another odb linked to HSQLDB and the form working as expected.
The error seems to be outside our scope.
These are the changed odb linked correctly.
Nein dear, I needed something else: the form working. You said it works if you link it to an hsqldb so I needed an Odb that doesn't point to access but to an hsqldb and with the form working as expected.