So I was working yesterday in a coffee shop with free wifi that knocks you off and forces you to log in again after an hour.
Access never complained about being disconnected.
While I was unknowingly disconnected I continued adding data to the database.
The shared backend file is on OneDrive so it looks like a local file on my system
Fortunately no data was lost because Access seems to have made local copies of everything.
So now I have an unsplit database again but when I went to the database splitter wizard it told me that there would be no tables in the backend!
So my question is, what exactly happened?
Why does Access not know how to split the DB again?
What should I do to recover the shared DB?
In the end, really the only thing that matters is that no data was lost. I am really the only user of the DB (I have colleagues who have access but they aren't actively using it.) One solution, probably what I will do, is to simply save it all as a local DB and then resplit the newly saved version.
Thanks
Access never complained about being disconnected.
While I was unknowingly disconnected I continued adding data to the database.
The shared backend file is on OneDrive so it looks like a local file on my system
Fortunately no data was lost because Access seems to have made local copies of everything.
So now I have an unsplit database again but when I went to the database splitter wizard it told me that there would be no tables in the backend!
So my question is, what exactly happened?
Why does Access not know how to split the DB again?
What should I do to recover the shared DB?
In the end, really the only thing that matters is that no data was lost. I am really the only user of the DB (I have colleagues who have access but they aren't actively using it.) One solution, probably what I will do, is to simply save it all as a local DB and then resplit the newly saved version.
Thanks