X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Database Corrupts Daily, Access 2016    
post Nov 13 2019, 01:28 PM

Posts: 121
Joined: 13-June 06
From: Cape Town, South Africa


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

Go to the top of the page
Start new topic
post Nov 13 2019, 03:47 PM

Posts: 1,104
Joined: 26-January 14
From: London, UK

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.
Go to the top of the page
post Dec 30 2019, 12:27 PM

Banned Spammer
Posts: 2
Joined: 30-December 19

Sometimes it runs for a day without corruption, then 3 times the following day.
Go to the top of the page
post Dec 30 2019, 12:30 PM

UA Moderator
Posts: 78,112
Joined: 19-June 07
From: SunnySandyEggo

Hi kawtary. Welcome to UtterAccess! welcome2UA.gif

Are you the same person as mhagen?

Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page

Posts in this topic

Custom Search

RSSSearch   Top   Lo-Fi    29th May 2020 - 01:21 AM