open access database in libreoffice base

For the GUI you would have to code it yourself maybe using php which allows for html form fields, and also carry out crud operations. if you could you would set up schema on a database, you then set up database fields to match and with some hockery pockery it would be possible in theory to export. exe window files are, then there isn't going to be a fully fledged way of transfering. If jet database is unique and selective, say like. That depends on how selective the system is php, java, python all run on Windows and Linux because off the top of my head Microsoft had nothing to do with their creation & were forced to go with the flow. It depends how tied in the jet database is to Windows, because i think ms-access is more than just a database, its a gui using ? you mention VBA thats not visual basic is it ?Īnyway one approach would be you dump the data from ms-access. So if there is a component that is not 'platform dependent' you would be Ok. I've not used sqlite3 on Windows but i'm fairly confident you can useit.

Now if you say had a a lot of information on say MyQL, and were using it on Windows then i might suggest to do a database dump into an sql file or equivalent, which looking at it from a birds eye view should allow you to import that(with a few caveats) onto a MySQl database used from Linux. In terms of connecting to a MySQl database drivers are available on Windows and Linux for say php language ,so that crud queries can be done. Lets start with say MySQl that needs a database server or daemon to run but it can be run on Windows via say a variation of a package from apachefriends The only way I can look to give you answer is for me to think of the components and what they need to run.

Open access database in libreoffice base