I have Access 2019. My database file is on a "server" and three or four users connect at a time. From time to time, I make small design changes from one of
the work stations. Every once in awhile, the database becomes corrupt. One is an can't find an id index (or something like that) and you can not use the database.
The other error is the database is inconsistent and Access repairs it.
I've moved the database (when I make design changes) file to a local computer and seems to be less susceptible to corruption.
Any ideas to make my database more stable? Slit the database? Upgrade to 2020? Or something else.
Thanks...
the work stations. Every once in awhile, the database becomes corrupt. One is an can't find an id index (or something like that) and you can not use the database.
The other error is the database is inconsistent and Access repairs it.
I've moved the database (when I make design changes) file to a local computer and seems to be less susceptible to corruption.
Any ideas to make my database more stable? Slit the database? Upgrade to 2020? Or something else.
Thanks...