473,725 Members | 1,996 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Corruption when "Compact on Close" active

I have a strange problem that has reared its ugly head in the last few
weeks.
I have the option "Compact on Close" (Tools, Options, General tab)
enabled on my development machine. I did this because every time I
worked on my app it just grew and grew.
What started out as a 14Meg file kept growing into a monster of over 90
Megs!

System info:
Windows XP Pro with SP1
Office XP Pro with Frontpage
Office XP Dev Ed (We bought the Developer Edition of Office XP)
All three service packs for the Office above.
512 Megs RAM
5 Gigs of free uncompressed disk space where the MDB file is located.

OK - here's the problem: after about 4 days, sometimes less, I can no
longer use the MDB file. It becomes corrupt, but in the strangest way. I
can access most of the forms, all of the queries and some of the modules.
The corruption happens to random forms and modules, so there is no
pattern there.
Luckily, I keep daily backups, but this isn't a solution - more of a "fix".

Has anyone had this happen to them? I've searched Google, plus many
other search engines, but I have so far found nothing.

Thanks in advance.
Smitty the crank.
Nov 13 '05 #1
1 2098
Smitty, for what its worth, here's my experience:

I've had a couple of situations where either some previously unknown
corruption in the database was made worse by auto compacting or the "compact
on close" process itself failed, leaving the database in a bad state. I was
fortunate in that I didn't lose anything; however, because of those close
calls, (and also because of my particular dislike of retyping code) I've
adopted a different view of the compact on close feature and now rarely use
it unless the application is totally replaceable with little or no risk of
loss (as in, for example, a production copy of the front end of a split
database).

My experiences made me realize how the compact on close feature exposes
greater potential for object/code loss for me as a developer and data loss
for my users. Now, instead of using compact on close, I instruct my users
to do compacting as a part of a formal periodic maintenance procedure and I
also instruct them to create a backup copy before compacting.

Using the compact on close feature might save you some time and effort right
now but if the day ever comes when you suffer irretrievable code or data
loss following an auto compact, you'll be wishing you had a backup. Taking
the extra time to back your database up before compacting is like insurance
that just might pay off some day.

"smitty mittlebaum" <sm****@hotmail .com> wrote in message
news:cb******** **@newsreader02 .ops.uunet.co.z a...
I have a strange problem that has reared its ugly head in the last few
weeks.
I have the option "Compact on Close" (Tools, Options, General tab)
enabled on my development machine. I did this because every time I
worked on my app it just grew and grew.
What started out as a 14Meg file kept growing into a monster of over 90
Megs!

System info:
Windows XP Pro with SP1
Office XP Pro with Frontpage
Office XP Dev Ed (We bought the Developer Edition of Office XP)
All three service packs for the Office above.
512 Megs RAM
5 Gigs of free uncompressed disk space where the MDB file is located.

OK - here's the problem: after about 4 days, sometimes less, I can no
longer use the MDB file. It becomes corrupt, but in the strangest way. I
can access most of the forms, all of the queries and some of the modules.
The corruption happens to random forms and modules, so there is no
pattern there.
Luckily, I keep daily backups, but this isn't a solution - more of a "fix".
Has anyone had this happen to them? I've searched Google, plus many
other search engines, but I have so far found nothing.

Thanks in advance.
Smitty the crank.

Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

12
2149
by: Stephen Ferg | last post by:
I've just spent several very frustrating hours tracking down a bug in one of my programs. The problem was that I was writing text to a file, and when I was done I coded f.close when I should have been coding f.close()
4
7092
by: Peter Pagé | last post by:
Hi, I've got a window with a "<body onBlur="window.close()"> tag that keeps closing prematurely. It happens when the user clicks on text inside a table in the same window. Apparently IE decides that the <body> no longer has the focus if the <table> within the <body> has it. Firefox handles the page correctly as does MS 5. This may be one of those "security features" that came along with Windows XP SP2, but wherever it came from,...
19
14053
by: Lauren Wilson | last post by:
A2K app: Question: is the flagged line (<<<) below necessary. If that line is needed, what effect does it have (if any) on the fact that the very same database is the linked back end db? Dim db As DAO.Database Dim rst As DAO.Recordset
7
3012
by: Willem van Rumpt | last post by:
Hi all, coming from an unmanaged programming background, I took my time to sort out the IDisposable and finalizer patterns. Just when I thought I had it all conceptually neatly arranged, the "Close()" methods reared their ugly (at least it would seem...)heads. I was happily delving away in the .NET framework, investigating the stream classes with the msdn and Lutz Roeder's .NET reflector, when I stumbled upon the following:
4
14474
by: stevong | last post by:
It works on Konquerer though. I remember it works on IE too. I've tried window.close() too. Doesn't work on Firefox also. I've also tried to create a function. It doesnt work on Firefox also. Bottomline is: Firefox doesn't accept window.close() or self.close()? Are there ways to rectify the issue? Please advise.
5
3094
by: lindanr | last post by:
In ASP.NET 2005 I have an onblur="window.close()" javascript event in the <body> tag. When I click on the window's scrollbar, the window closes. The same code works fine in ASP.NET 2003. Any ideas?
0
1435
by: Greg Larsen | last post by:
How add the "Active File" icon (down arrow), and the "Close" icon (X) next on TabPage in the gray space next to the tabs, so when I click on the X the active Tab closes, and and when I click on the down arrow the All active tabs are displayed.
9
18849
by: Beowulf | last post by:
I was having this problem: http://groups.google.com/group/microsoft.public.sqlserver.server/msg/e36e423972323378?dmode=source with it taking an inordinate amount of time to enumerate the databases on my local SQL Server instance, so I went through all the local databases and unchecked "Auto Close" on the "Options" tab of the Database properties in Enterprise Manager. This cleared up the problem nicely. In EM or through SQL-DMO, the...
1
2770
by: liu | last post by:
I have some thumbnails and once clicked it creates a new window. I don't want extra windows everywhere so I'd like it to auto-close when it's in the background. I've found <body onBlur="self.close()" onClick="self.close()"to do the trick, but some windows are longer than 1 page that a user need to scroll the window to see it. With the script above, it closes even when clicked. I took onClick="self.close()" out but it still does the same...
0
8886
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9256
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9105
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6701
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6010
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4509
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3218
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2632
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2154
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.