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,069
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
 
kawtary
post Dec 30 2019, 12:27 PM
Post#3


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
 
theDBguy
post Dec 30 2019, 12:30 PM
Post#4


UA Moderator
Posts: 77,708
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 March 2020 - 04:41 PM