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,052
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

Posts in this topic

Custom Search

RSSSearch   Top   Lo-Fi    27th January 2020 - 05:19 AM