UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

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



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


Hi

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:

https://www.devhut.net/2018/06/13/access-bu...ognized-format/

I am really desperate for any advise. crazy.gif

Thank you

Marlie
Go to the top of the page
 
 
Start new topic
Replies
nvogel
post Nov 13 2019, 03:47 PM
Post#2



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    25th January 2020 - 06:25 AM