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

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Closed TopicStart new topic
> Compacting and Repairing an Access Database On a Network    
 
   
Candace Tripp
post Dec 10 2003, 12:50 PM
Post#1


UA Admin & Utter Angel
Posts: 3,039
Joined: 30-January 00
From: Virginia, USA


FROM VERY VERY BITTER AND HARD WON EXPERIENCE:
If you compact and repair a database over the network, MOST of the time there is no problem.
HOWEVER, once in a while, when the network hiccups while Access is doing its business, the database will SEEM to have been C&R'd successfully. But then, mysteriously, things will begin happening. You will think poltergeists have taken possession of your precious database. You will C&R again and again and Access will lie to you and tell you that all is well with your world.
Objects will begin to error, e.g. you will find that you can't open forms in design mode then you can't access them at all. Same with all other objects, INCLUDING YOUR TABLES AND DATA. And each time you open this sick sick database, the problems will get worse. Eventually you will not be able to open it at all. All you will get is one of those oh-so-unhelpful Microsoft error messages. Which message you get will vary and may in fact vary to attempt to attempt.
HOWEVER,
If you take a database that you, in ignorant newbie error, HAVE C&R'd over a network, create a new database container, and one by one (I'm not kidding here) import your objects, C&Ring after each import, you can save all your hard work. After doing this, hold your nose, take the old copy of the db between finger and thumb, and gingerly throw it into the nearest Recycle Bin and empty it. Do not go back and mourn over your lost db; it is dead dead dead.
Oh, Harken to your Surrogate Access Mother, or the Angels will weep for you, for you will have lost ALL!
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    13th December 2017 - 05:21 PM