Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Database Container _ Database Corrupts Daily

Posted by: mhagen Nov 13 2019, 01:28 PM


I have a database on a clients server that has been crashing/corrupting a couple of times a day for the past 3 weeks.

I have about 45 users and it is a split database. Data on the server and each user has his own front end. This database has been running smoothly for about 5 years.

I have decompiled
Compact and repaired
Removed everyone off wifi
Removed SQL links
Created blank db and imported tables

Sometimes it runs for a day without corruption, then 3 times the following day.

I am at a point where if I can't fix this, I will need to move to SQL

I have seen this workaround, but it involves a lot of things on the network. Has anyone done this:

I am really desperate for any advise. crazy.gif

Thank you


Posted by: theDBguy Nov 13 2019, 01:45 PM

Hi Marlie. Does that bug apply to you? I mean, is your Windows version one of those affected? If so, I can tell you the "fix" worked for me in more than a couple of times.

Posted by: mhagen Nov 13 2019, 01:57 PM

I only work on this database once a week. Even when I am not there, it crashes. I don't think it is the database itself, but either the network, or someone's pc making it corrupt.

Sometimes some of the people can continue working, but for others its shows corrupted. If they go out and back in, it shows corrupted and I need to do a compact and repair.

I have been working on db's for 20 years now and never had this. I actually smiled when I saw I am a member since 2006 notworthy.gif

The IT people says that doing this registry change is a big thing, so if I can fix it without doing the registry, it would be great, otherwise they need to suck up and change it.

Any other thoughts?


Posted by: theDBguy Nov 13 2019, 02:01 PM

Hi. If something in Windows is broken, there's nothing you can do in Access to fix it. So, I would definitely ask IT to try the Registry fix. However, I also know it didn't help everyone who tried it (probably due to other reasons). Good luck!

Posted by: nvogel Nov 13 2019, 03:47 PM

I suggest you look into moving the database to a SQL DBMS. Irrespective of any actual corruption issues, having 45 users reliant on sharing an ACE database seems like a pretty high and unnecessary risk.

Posted by: kawtary Dec 30 2019, 12:27 PM

Sometimes it runs for a day without corruption, then 3 times the following day.

Posted by: theDBguy Dec 30 2019, 12:30 PM

Hi kawtary. Welcome to UtterAccess! welcome2UA.gif

Are you the same person as mhagen?