Upgrading the functionality of a running Access database. Is it possible to?

Question

Microsoft Access

I'm creating an Access database, bro to work. The main functionality works and is being tested in combat conditions.
Tomorrow maybe something will have to be added or sawed off.
Is there any way to update.

Or is it better to start with some other approach before it's too late.

Answer 1

First, you need to split the data and code into two files.
Second, consider auto-disconnection of users from the database, for example, at midnight.
For the update, you will only need to replace the file with the code. If users "pull" this file onto their PCs, check the version (a separate field in the database). If the version does not fit - the program should display a window with information - where to get the new version.