B4J Question Using MS Access

[Cotswold]

I have seen posts regarding MS Access databases being used remotely. The situiation as I understand it is that Access requires a constant connection and not an intermittent one.
It is therefore susceptable to corruption and I would not myself consider its use except on a PC or a local network. It is not advised that an Access database is used on a local WiFi connection as that will also cause major problems.

Access does not work for most cloud sites because those sites do not support the Server Message Block (SMB) protocol that is the Windows standard protocol for "File and Printer Sharing" operations. No SMB? No Access. The few places that seem to have some type of solution either use a single-user with remote-mirror system, or they use another protocol called Remote Desktop Protocol (RDP).

Additionally, an Access database will bloat and must be regularly compacted and repaired. It will even bloat if simply opened or closed. Any flaky or intermittent network can easily corrupt an Access database, which will result in several or dozens of records being destroyed. Or often subject to 'slip' where the content of one record slips into another.
If the Unique Record Number is used as a link to related data, then that link may well be lost and can never be recovered. Compacting and repair will result in bad records being deleted and the missing unique numbers can never be recovered or replaced. If you cannot relpicate the compact and repair from Access you will have issues.

My advice is that if you are thinking of using an Access database outside of an Access development.........don't.

 

[amorosik]

Actually Access can also connect to databases, read / write, and then disconnect, it is not necessary that the connection is always active
Even if this is not the classic mode of use As for compaction, in reality it is only useful in the development environment, while if you distribute the mde or accde file it is not necessary
The main point is that Access was not born and is not suitable for creating web applications, and if you try to use it for these things it is normal that great difficulties arise
It is also true that Access allows you to quickly create both single-user and multi-user desktop applications with a speed that is difficult to reach with other environments.
In case it's not clear, I think Access is an excellent development environment for the things it was designed for

 

[Magma]

I have seen posts regarding MS Access databases being used remotely. The situiation as I understand it is that Access requires a constant connection and not an intermittent one.
It is therefore susceptable to corruption and I would not myself consider its use except on a PC or a local network. It is not advised that an Access database is used on a local WiFi connection as that will also cause major problems.

Access does not work for most cloud sites because those sites do not support the Server Message Block (SMB) protocol that is the Windows standard protocol for "File and Printer Sharing" operations. No SMB? No Access. The few places that seem to have some type of solution either use a single-user with remote-mirror system, or they use another protocol called Remote Desktop Protocol (RDP).

Additionally, an Access database will bloat and must be regularly compacted and repaired. It will even bloat if simply opened or closed. Any flaky or intermittent network can easily corrupt an Access database, which will result in several or dozens of records being destroyed. Or often subject to 'slip' where the content of one record slips into another.
If the Unique Record Number is used as a link to related data, then that link may well be lost and can never be recovered. Compacting and repair will result in bad records being deleted and the missing unique numbers can never be recovered or replaced. If you cannot relpicate the compact and repair from Access you will have issues.

My advice is that if you are thinking of using an Access database outside of an Access development.........don't.

I agree... in 90%

I am using Access MDB databases with VB6 ....at least 20 years now... and never had bad records... corrupted databases... Also I was using them with asp classic as online db... with concurrent users more than 300 !!!!! and worked very well... but not with those superspeeds of today!

But I will agree that access databases not the right choice for 2022 !

For me... best DataBases are mariadb, mysql, mssql for any use... and for local use... sqlite...