Our Access databases uses "Workgroup Security" to control group/user permission to view/maintain data?

Our Access databases uses "Workgroup Security" to control group/user permission to view/maintain data?

This question points out what is a fundamental difference between AOO Base and MS Access (MSA). In the case of MSA there is one and only one database engine in use - although you may link tables in MSA to external datasources - MS Jet is still the only database engine actually used by MSA.

In Base (AOO Base) this is not the case at all. The Base database document is simply a front end (client application) to a variety of database engines. In one of these forms it embeds a HSQLDB database into the ODB file itself, many people simply see this as the only Base database format. That is totally mistaken. In this instance of an embedded database there is no support for multiple users and of course no support for groups therefore. However, that is only one of the ways Base can be configured.

You are free to use Base as the front end to a HSQLDB database in server mode. HSQLDB is a very small footprint, low administration database engine and in server mode has full support for users / groups. For larger numbers of users you could just as easily configure Base to work with MySQL, PostgreSQL, Firebird, Oracle, or MS SQL Server.

There is another significant difference between MSA and Base regarding this then. In MS Access you would deploy one MDB (or one of its variants) file, then have each user in the workgroup see this file and open it.

In Base each user would have their own ODB file and each of these would be connected to the shared data server. In this way each user would have their own space for custom queries and reports - but it makes distribution of common forms, queries and reports more work.