Front End Corruption

[Guest]

I have a split DB that recently started corruping on the front end (it
happened twice). Will running an MDE resolve that issue? Thx, Dj

 

[Armen Stein]

I have a split DB that recently started corruping on the front end (it
happened twice). Will running an MDE resolve that issue? Thx, Dj

It might. But you should first ensure that only one person is using the
front-end at a time. Each user should have their own copy of it.

Also, make sure that Name AutoCorrect (in Tools|Options) is turned off.

Even with a separate front-end for each user, there are some coding
practices that can increase the chance of corruption, like automating
other Office programs and not cleaning up their objects, creating and
deleting front-end database objects, etc.