Hopefully, this is the correct place for this question. I created an access database and split it, I want to run two copies of the front-end in parallel using a local network, the first on a windows PC and the second on an android-tablet
I have only one PC, so I have to choose one of these two options:
- Install remote desktop app on the tablet, and work on the database remotely, but this will lock the PC during the remote session
- Install tools like team-viewer, but in this case this will create some chaos where the PC and the tablet are working both at the same time
I also tried the following scenario, create two users on the PC, the first user logs in and runs the database, and then the tablets remotes the second user (which is not logged in of course), but still the same problem, the PC is locked during the remote session.
Any idea how to open the database on the tablet without affecting the PC?