Hello, It is possible to import by any means or even a boost a access Forms, Reports, and Queries in the base databases.
No, you can’t import forms, reports, macros.
Base can only get access to Access’s tables but as you wrote
[quote=“Bacardi4life, post:1, topic:84787”]
by any means
[/quote] you could hire somebody …
If you start a project like this, begin with the question of database as embedded HSQL is the default, but may not be the best choice for every project. Also it is a good time to check, if something is to be changed. As there are differences even on level if SQL, transitions are usually not easy - except for simple projects.
I hope they made an educated decision on using hsql-embedded, wich I only use, if the database is to be sent around by mail/dropbox etc. Base also brings firebird as database, for both there is also an installed variant available and Base could use MariaDB/MySQL, Postgres or Sqlite to name some options.
I have no choice the job asks me for a one-time mission to transfer all data access to base and only in base @Wanderer
an agent created the database ten years ago to facilitate the work of these colleagues but today because office will not be renewed he hires me to redo everything in base.
and I don’t know the databases in general
Please don’t write “Answers”, which always should be comments.
Base has internal databases like HSQLDB and Firebird. Base could also connect to external databases, which could also be databases like MySQL/MariaDB, PostgreSQL. Connecting to external files is also possible with the internal versions of HSQLDB or Firebird.
You need to connect to Access file through Base, copy the different tables and past this tables into a new Base *.odb - which might connect internal or external to a database.
First step will be to copy all the tables into an internal database. If you need functions like DATEADD (adding a time value to a date or something like this) or GROUP_CONCAT (Grouping strings in one field, separated by a defined separator - function LIST in Firebird) I would use internal Firebird. If you don’t need this functions unse internal HSQLDB. Integration in Base is better at this moment.
Makes absolutely no sense. The LO Base component did not change significantly in 10 years. Base is a tiny addition to this office suite whereas Access is a full featured database development suite. Even a 20 year old Access solution can be “better” than anything you will ever accomplish with Base.
What you really should do: Transfer the actual database (tables, indices, relations) to some future safe and non-proprietary database such as PostgreSQL or MySQL while keeping the Access frontend (queries, forms, reports, macros). MS Access is a superb frontend to 3rd-party databases.
We can’t know. If it is some simple database and the only reason to have a license for MS-Office I’d also remove the vendor-lock. (Especially if I don’t want to throw away several office-computers because of Win11.)
.
Last week I’ve seen a 10 year old database solution on Mac. The backend is a great database, but not necessesary to put 20 addresses a day on parcels. And as nobody is there to update the interfaces to UPS, DPD, Hermes etc. the user does simple copy’n’paste to webinterfaces. So a migration to base with export to current csv-files could be a real improvement even with a solution on dbase or sqlite-files.