Forum Discussion
Sharing Access in Windows 11
As you've learned, it is not advisable to try to use OneDrive with Access, for the very reason you report. OneDrive is not designed to support the kind of usage shared Access database applications require.
You need to restore the peer-to-peer networking arrangement you used previously in order to share the back end.
We can't really help you directly; that would require someone to have access to your computers.
We can explain the steps, though.
Join both computers to the same WorkGroup as shown here. Make sure you use the WorkGroup option; you don't have a Windows Domain. Create a WorkGroup Name that reflects your environment. This is just a sample.
Pick one of the two computers to be the "server". Create a shared folder on it and put the Back End accdb in that folder.
Relink the Front End accdbs on both computers to that Back End.
Obviously, the "server" machine will have to remain powered on for the other user to be able to work with the database application.