473,394 Members | 1,797 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Compact on Close + mda or mde reference = CRASH

I develop and maintain many Access 2003 databases and about a week ago
all mdb front ends started crashing Access after compacting on closing.
The problem doesn't occur with compiled mde versions though.

Posts about this type of problem indicated they were often related to
vba references. By trial and error I found that the crashes only
occured in mdbs that reference mda or mde files.

This can easily be tested by creating a blank mdb, opening the vba ide
and setting a reference to utility.mda in the OFFICE11 folder or any
other mda or mde. You also need to have at least one empty module
compiled and saved. Set 'Compact on close' and then close the mdb.

I've tried this on two PCs running Office 2003 SP2 on XP Home and Pro.
It may just have been coincidence but the problem started shortly after
the O2003 SP2 update was installed.

Can anyone reproduce this problem?

Nov 13 '05 #1
2 2157
Yes.
The crash occured if I opened the Visual Basic Window. It did not if I
used only the Access window.

Nov 13 '05 #2
And it seems that "Compact" is the cause, rather than "Compact on
Close" as I can duplicate the crash by compacting using the UI, without
closing.

Nov 13 '05 #3

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

Similar topics

13
by: James Franklin | last post by:
Hi, I have a number of databases in A2K, written on different machines with different installations of Office. I have found that compacting a database while it is open regularly fails, seemingly...
0
by: Rick Collard | last post by:
I can consistently crash Access 2002 SP2 using a /runtime switch on an mdb that has the Compact on Close property set after opening and closing a form that uses the References collection. Remove...
1
by: smitty mittlebaum | last post by:
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...
4
by: Wayne | last post by:
Does "Compact On Close" do a "Compact and Repair" or just a compact. Is a compact necessary (or at least a good idea) on a regular basis, say weekly, for a database that has several hundred records...
1
by: robert demo via AccessMonster.com | last post by:
In my startup routine, I have the following code: s = CLng(FileLen(filespec) / 1000000) If s > 5 Then 'FIRST, BACKUP THE FRONT END If BackupFrontEnd = False Then Exit Function End If
5
by: SheldonMopes | last post by:
Here is my situation:I have several Access database projects that all keep their back-end data in a directory on a server. I would like to have a small Access application that could open each .mdb...
0
by: Rick | last post by:
hi all ! i need your HELP ! (it's long to explain but it's needed) i have a big problem (for me) with my APP/DLL i have made an Application with VB.NET for Compact framework that call an...
1
by: hamlet1 | last post by:
Back in November 2005 I posted an item about a problem I was having with Access 2003 SP2 crashing when attempting to compact an mdb file that had refererences to mda or mde files. It would crash...
2
by: Greg Wood | last post by:
As a new member, I hope I am posting correctly. Bear with me if not ! I found a posting by Earle Oxner that very closely matches the situation we are in. Sadly, there were no replies to his post,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
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...

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.