473,685 Members | 2,719 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Compact on close - bad idea?

Is it?
Nov 12 '05 #1
35 17045
Mike MacSween wrote:
Is it?


The user might not appreciate it. Then they might take a shortcut and close
the Access window rather than click on your command button. I'm sure there
are technical considerations but I'm don't know what they are.
Nov 12 '05 #2
Most apps I work on are split front/back end, so Compact on close is not
much use. I usually provide a separate Access MDB that provides
maintenance services such as compact-back-end.

On Wed, 17 Sep 2003 21:39:00 +0100, "Mike MacSween"
<mi************ ******@btintern et.com> wrote:
Is it?


Nov 12 '05 #3
It probably won't HURT anything. But why not compact on a regular schedule
(e.g., compact if the mdb hasn't been compacted in the past n days)? There's
code available to do this in various ways, I think (if not, I can post my
own kludgey code). Why compact if a user opens the database, looks at a
record, and closes it again? The performance loss would be greater than any
benefit from the compacting. You could base the decision to compact on the
number of days since last compacting, the number of uses (have a table with
one record which incremements by one when the database is opened), or
whatever else you want.

The only situation I could see it is a machine that is up all the time,
running a database continuously, but in that situation I'd look for a more
robust solution.

HTH,

Bruce Rusk
"Mike MacSween" <mi************ ******@btintern et.com> wrote in message
news:3f******** *************@p ubnews.gradwell .net...
Is it?

Nov 12 '05 #4
Er, it's an application option. I don't need to set up a command button

"Deano" <ma************ @hotmail.com> wrote in message
news:33******** ***********@war ds.force9.net.. .
Mike MacSween wrote:
Is it?
The user might not appreciate it. Then they might take a shortcut and

close the Access window rather than click on your command button. I'm sure there are technical considerations but I'm don't know what they are.

Nov 12 '05 #5
Mine too. But there are a couple of temp tables in the front end.

How do you schedule your maintenance services then?

Mike

"Steve Jorgensen" <no****@nospam. nospam> wrote in message
news:c7******** *************** *********@4ax.c om...
Most apps I work on are split front/back end, so Compact on close is not
much use. I usually provide a separate Access MDB that provides
maintenance services such as compact-back-end.

On Wed, 17 Sep 2003 21:39:00 +0100, "Mike MacSween"
<mi************ ******@btintern et.com> wrote:
Is it?

Nov 12 '05 #6
It does it at the moment. I don't see any performance impact. I was more
worried about risks of corruption.

Mike

"Bruce Rusk" <ho**********@s pamless.ucla.ed u> wrote in message
news:bk******** **@gladiola.noc .ucla.edu...
It probably won't HURT anything. But why not compact on a regular schedule
(e.g., compact if the mdb hasn't been compacted in the past n days)? There's code available to do this in various ways, I think (if not, I can post my
own kludgey code). Why compact if a user opens the database, looks at a
record, and closes it again? The performance loss would be greater than any benefit from the compacting. You could base the decision to compact on the
number of days since last compacting, the number of uses (have a table with one record which incremements by one when the database is opened), or
whatever else you want.

The only situation I could see it is a machine that is up all the time,
running a database continuously, but in that situation I'd look for a more
robust solution.

HTH,

Bruce Rusk
"Mike MacSween" <mi************ ******@btintern et.com> wrote in message
news:3f******** *************@p ubnews.gradwell .net...
Is it?


Nov 12 '05 #7
"Mike MacSween" <mi************ ******@btintern et.com> wrote:
Mine too. But there are a couple of temp tables in the front end.


Put them in a seperate MDB. See the Temp Tables page at my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #8
I try to avoid putting temp tables -in- the front-end. I'll generally try
to create a separate temporary database file on the front-end instead.

On Thu, 18 Sep 2003 03:53:54 +0100, "Mike MacSween"
<mi************ ******@btintern et.com> wrote:
Mine too. But there are a couple of temp tables in the front end.

How do you schedule your maintenance services then?

Mike

"Steve Jorgensen" <no****@nospam. nospam> wrote in message
news:c7******* *************** **********@4ax. com...
Most apps I work on are split front/back end, so Compact on close is not
much use. I usually provide a separate Access MDB that provides
maintenance services such as compact-back-end.

On Wed, 17 Sep 2003 21:39:00 +0100, "Mike MacSween"
<mi************ ******@btintern et.com> wrote:
>Is it?
>


Nov 12 '05 #9
Mike MacSween wrote:
Er, it's an application option. I don't need to set up a command
button

"Deano" <ma************ @hotmail.com> wrote in message
news:33******** ***********@war ds.force9.net.. .
Mike MacSween wrote:
Is it?


The user might not appreciate it. Then they might take a shortcut
and close the Access window rather than click on your command
button. I'm sure there are technical considerations but I'm don't
know what they are.


Oh, I forgot about that! Well my point was that if it slows down the
experience of using the app then it might hack some people off, even if they
know what it's doing.
Nov 12 '05 #10

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

Similar topics

13
5072
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 at random. This is especially annoying as I usually set the Compact on Close setting in Tools/Options to true. Has anyone else experienced this and is there a fix? Thanks for any help,
1
2097
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 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
6
5569
by: KEVIN97810 | last post by:
Hello to all, Assume my mdb name is Cust.MDB. I want to compact & repair the same Cust.MDB when the user exit the program. Is there a way you can do it in code behind the EXIT button. I am dumping data from SQL to temp table and also delete from these tables in Cust.MDB. This would cause the MDB to get big. So I just want some code to compact and repair as user Exit from the access database. thanks a bunch.
5
9747
by: Susan Bricker | last post by:
Greetings. I just discovered the 'Compact on Close' option in Access-Tools-Options-General Tab. It certainly sounds like a smart idea to me. But before I turn that option on I thought I'd check with the experts to see if there are any reasons why I would not want to 'Compact on Close'. Can you think of any? Thanks. SueB
4
2079
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 per week added to it? TIA.
1
4818
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
3
2174
by: G Gerard | last post by:
Hello The more I use an application ( an mdb) created using MSAccess I notice that the Byte size of the application keeps on increasing. Once in a while I do a Compact and Repair Database (under Tools in MSAccess) on the application and the size then returns to normal.
9
3987
by: Ron | last post by:
New discovery. If I take a perfectly good database, and "compact/repair" on it with Access 2000 (seems to be at multiple sites--I've tried it with my system here, at another office on an entirely different network), it damages the file somehow. The user's machine that did the compact/repair can see the file fine. But any networked user can't get in. I can double click on a good database file from any user (over the network) and it...
0
2833
by: ARC | last post by:
Hello all, Due to some users experiencing severe front end bloating (Normal compacted front end .accdr is 27MB's, FE can bloat to 80-90+Mb's in a day), I want to enable the "Compact on Close" option on the front end, and distribute in a runtime installation. I do have my share of update / append queries, and I've always suspected that they are the main culprit, but it's hard to say. One strategy I tried was to move the frequently used...
0
8512
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
8763
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7591
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6436
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
5793
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
4303
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
2941
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
2199
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
1931
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.