I wouldn't sell an Access application to a customer anyways. I would rewrite the FE in .NET6\C#\WinUI3. I would have a similar BE update routine in my FE software, it would just be an .EXE instead of an .ACCDE
You're making a lot of assumptions here. I already said that I do my updates myself. You really should look at the backend updater before you keep going. It doesn't proceed if the BE is open. It also opens it in exclusive mode so nobody else can access it.
If you are shipping to a customer the...
@The_Doc_Man Step 3 is the staging environment I was talking about. I apologize if I was unclear. If you can get it working in the staging environment then your chances of success is high. (I've had 100% success with this over the last 4 years)
You do need good communication for steps 4 and 5...
I apologize, it won't let me post links but these are open source things you can find on the internet.
I use the Application Starter by peterssoftware to keep the FE always up to date.
The users always run the application starter, which is shared on the network. It performs backups of the BE...
Thanks @Xyloz! I am one of those people who had a convoluted way of refreshing my form after I wanted to remove an item from a step. I am trying your simple solution and testing is going well. I appreciate the explanation that we want to refresh the data and not the form. Makes sense.