100 Day Statistics for comp.databases. ms-access

edo

[view with fixed-spaced font]

100 Day Analysis

Following is a summary of articles spanning a 100 day period,
beginning at 10 Sep 2003 06:41:30 GMT and ending at
19 Dec 2003 04:09:06 GMT.

Notes
=====

- A line in the body of a post is considered to be original if it
does *not* match the regular expression /^\s{0,3}(?:>|:| \S+>|\+\+)/.
- All text after the last cut line (/^-- $/) in the body is
considered to be the author's signature.
- The scanner prefers the Reply-To: header over the From: header
in determining the "real" email address and name.
- Original Content Rating (OCR) is the ratio of the original content
volume to the total body volume.

Totals
======

Posters: 2240
Articles: 12479 (2166 with cutlined signatures)
Threads: 3353
Volume generated: 27350.2 kb
- headers: 12010.8 kb (208,575 lines)
- bodies: 14455.8 kb (435,570 lines)
- original: 7662.3 kb (245,013 lines)
- signatures: 871.4 kb (28,461 lines)

Original Content Rating: 0.530

Averages
========

Posts per poster: 5.6
median: 2.0 posts
mode: 1 post - 1046 posters
s: 20.5 posts
Posts per thread: 3.7
median: 3 posts
mode: 2 posts - 844 threads
s: 4.3 posts
Message size: 2244.3 bytes
- header: 985.6 bytes (16.7 lines)
- body: 1186.2 bytes (34.9 lines)
- original: 628.8 bytes (19.6 lines)
- signature: 71.5 bytes (2.3 lines)

Top 10 Posters by Number of Posts
=============== =============== ===

(kb) (kb) (kb) (kb)
Posts Volume ( hdr/ body/ orig) Address
----- -------------------------- -------

414 1040.4 (442.3/597.6/179.5) "TC" <a@b.c.d>
337 538.9 (298.5/240.1/141.5) Pieter Linden <pi********@hot mail.com>
330 741.7 (322.2/419.2/208.2) "Larry Linson" <bo*****@localh ost.not>
273 797.2 (280.9/478.5/258.5) David W. Fenton <dX********@bwa y.net.invalid>
194 456.6 (212.2/244.2/141.6) "Mike MacSween" <mi************ ******@btintern et.com>
191 591.6 (230.2/360.1/161.8) MGFoster <me@privacy.com >
189 564.0 (195.0/368.8/161.1) Steve Jorgensen <no****@nospam. nospam>
178 292.1 (167.4/124.5/ 88.7) Tony Toews <tt****@teluspl anet.net>
174 331.8 (164.0/167.6/ 51.4) Tom van Stiphout <to*****@no.spa m.cox.net>
166 460.0 (145.9/157.0/139.4) "Allen Browne" <al*********@Se eSig.invalid>

These posters accounted for 19.6% of all articles.

Top 10 Posters by Volume
=============== =========

(kb) (kb) (kb) (kb)
Volume ( hdr/ body/ orig) Posts Address
-------------------------- ----- -------

1040.4 (442.3/597.6/179.5) 414 "TC" <a@b.c.d>
797.2 (280.9/478.5/258.5) 273 David W. Fenton <dX********@bwa y.net.invalid>
741.7 (322.2/419.2/208.2) 330 "Larry Linson" <bo*****@localh ost.not>
591.6 (230.2/360.1/161.8) 191 MGFoster <me@privacy.com >
564.0 (195.0/368.8/161.1) 189 Steve Jorgensen <no****@nospam. nospam>
538.9 (298.5/240.1/141.5) 337 Pieter Linden <pi********@hot mail.com>
460.0 (145.9/157.0/139.4) 166 "Allen Browne" <al*********@Se eSig.invalid>
456.6 (212.2/244.2/141.6) 194 "Mike MacSween" <mi************ ******@btintern et.com>
398.5 (143.5/254.9/ 89.2) 127 "deko" <dj****@hotmail .com>
332.0 (160.0/ 49.3/ 48.1) 137 "Wayne Morgan" <co************ *************** @hotmail.com>

These posters accounted for 21.6% of the total volume.

Top 10 Posters by Volume of Original Content (min. five posts)
=============== =============== =============== =============== ==

(kb)
Posts orig Address
----- ----- -------

273 258.5 David W. Fenton <dX********@bwa y.net.invalid>
330 208.2 "Larry Linson" <bo*****@localh ost.not>
414 179.5 "TC" <a@b.c.d>
191 161.8 MGFoster <me@privacy.com >
189 161.1 Steve Jorgensen <no****@nospam. nospam>
27 149.4 "(Pete Cresswell)" <x@y.z>
194 141.6 "Mike MacSween" <mi************ ******@btintern et.com>
337 141.5 Pieter Linden <pi********@hot mail.com>
166 139.4 "Allen Browne" <al*********@Se eSig.invalid>
81 120.6 Peter Miller <pm*****@pksolu tions.com>

These posters accounted for 21.7% of the original volume.

Top 10 Posters by OCR (minimum of five posts)
=============== =============== =============== =

(kb) (kb)
OCR orig / body Posts Address
----- -------------- ----- -------

1.000 ( 6.5 / 6.5) 7 ano1optimist <an**********@a ol.com>
1.000 ( 8.0 / 8.0) 10 Ian <an*******@devd ex.com>
1.000 ( 5.4 / 5.4) 5 "edself" <ed****@ecomail .org>
1.000 ( 1.2 / 1.2) 5 bala <ba*******@yaho o.com>
1.000 ( 1.0 / 1.0) 5 Lynn <Ly***********@ yahoo.com>
1.000 ( 6.1 / 6.1) 5 "Tom Wickerath" <AO****@comcast .net>
1.000 ( 3.8 / 3.8) 6 Tom Dauria <td*****@bu.edu >
1.000 ( 2.9 / 2.9) 6 "Bob Darlington" <bo*@dpcmanAX.c om.au>
1.000 ( 6.7 / 6.7) 13 DCM Fan <dc****@aol.com SPNOAM>
1.000 ( 4.0 / 4.0) 7 Svelte Poshy <sv******@yahoo .com>

Bottom 10 Posters by OCR (minimum of five posts)
=============== =============== =============== ===

(kb) (kb)
OCR orig / body Posts Address
----- -------------- ----- -------

0.237 ( 1.4 / 6.0) 5 "John Ortt" <Jo******@STOPS PAMMINGMEbaesys tems.com>
0.234 ( 6.6 / 28.0) 12 "JustMe" <te******@saskt el.net>
0.230 ( 5.9 / 25.7) 7 "Andrew Gow" <an*******@oran ge.net>
0.223 ( 3.8 / 17.3) 9 Kenny G <kg****@hotmail .com>
0.217 ( 23.7 /109.1) 15 mark <ms@nospam.comc ast.net>
0.217 ( 3.4 / 15.5) 5 "Nifty" <as*@meifyouwan tknow.com>
0.217 ( 13.1 / 60.4) 50 "Phobos" <la******@spamm ers.co.uk>
0.190 ( 2.4 / 12.4) 7 Re*****@JaxonFa mily.net
0.146 ( 5.3 / 36.2) 10 Peter Flick <pf****@bigpond XXremoveXX.net. au>
0.070 ( 3.3 / 46.7) 6 "David Lauberts" <da************ @ntlworld.com>

412 posters (18%) had at least five posts.

Top 10 Threads by Number of Posts
=============== =============== ===

Posts Subject
----- -------

117 Security - more complex than I thought
67 Open question - leverage all features liberally, or be selective?
58 No 'real' relational databases?
52 Desire to REMERGE Database and Program!!
45 Compact on close - bad idea?
41 Time dependant PK?
37 OT: Yet Another Patch
33 How often is Access security breached?
30 BEWARE LINKS POSTED FROM ANONYMIZERS!
30 David Fenton is a valued member of this newsgroup

These threads accounted for 4.1% of all articles.

Top 10 Threads by Volume
=============== =========

(kb) (kb) (kb) (kb)
Volume ( hdr/ body/ orig) Posts Subject
-------------------------- ----- -------

441.1 (152.2/271.0/160.8) 117 Security - more complex than I thought
275.6 ( 81.7/190.9/ 88.5) 67 Open question - leverage all features liberally, or be selective?
169.6 ( 61.1/106.5/ 58.0) 52 Desire to REMERGE Database and Program!!
152.0 ( 70.0/ 79.7/ 38.4) 58 No 'real' relational databases?
145.8 ( 23.1/122.7/ 12.1) 17 Export of form with 2 graphs As a JPEG
130.5 ( 53.5/ 75.8/ 47.0) 41 Time dependant PK?
119.9 ( 6.3/113.6/111.2) 6 Why must I use PrtDevMode
101.3 ( 11.2/ 90.1/ 18.5) 8 Expressions and the IIf statement
99.0 ( 51.5/ 38.7/ 17.9) 45 Compact on close - bad idea?
95.1 ( 23.1/ 71.6/ 26.0) 20 Duplicated code in a class module

These threads accounted for 6.3% of the total volume.

Top 10 Threads by OCR (minimum of five posts)
=============== =============== ===============

(kb) (kb)
OCR orig / body Posts Subject
----- -------------- ----- -------

1.000 ( 2.3/ 2.3) 5 Newbie. How to delete blank lines in an address
1.000 ( 3.8/ 3.8) 9 Blank Form
0.983 ( 2.9/ 2.9) 6 don't show reminders form on startup
0.978 (111.2/ 113.6) 6 Why must I use PrtDevMode
0.977 ( 7.4/ 7.5) 5 populating textfield from multiple records
0.967 ( 2.9/ 3.0) 7 Playing & recording WAVE-type sound in MS Access - could Me!Message.Acti on ...
0.943 ( 4.5/ 4.8) 6 Filter By Selection Issue
0.921 ( 3.4/ 3.7) 5 Using MultiSelect List Box on a Subform
0.917 ( 2.4/ 2.6) 5 Compacting a database on close
0.891 ( 4.6/ 5.1) 8 Access 2002 Comments

Bottom 10 Threads by OCR (minimum of five posts)
=============== =============== =============== ===

(kb) (kb)
OCR orig / body Posts Subject
----- -------------- ----- -------

0.209 ( 9.8 / 46.9) 9 Combine field in several recs summarized into one record?
0.208 ( 7.1 / 34.4) 17 Putting my Access 97 database on the web
0.208 ( 1.0 / 4.9) 6 CodeModule Find Method regexp
0.206 ( 18.5 / 90.1) 8 Expressions and the IIf statement
0.204 ( 9.8 / 47.8) 9 Error Message After Delete
0.200 ( 4.7 / 23.7) 9 Cannot get the "like" command to work in a sql statement help please
0.197 ( 3.2 / 16.3) 7 Report formating problem
0.186 ( 6.2 / 33.3) 9 Passing typo to form gets runtime error 2105
0.141 ( 7.3 / 51.7) 15 query to define current week?
0.098 ( 12.1 /122.7) 17 Export of form with 2 graphs As a JPEG

758 threads (22%) had at least five posts.

Top 10 Targets for Crossposts
=============== ==============

Articles Newsgroup
-------- ---------

215 microsoft.publi c.access.formsc oding
143 microsoft.publi c.access.forms
116 microsoft.publi c.access.gettin gstarted
114 microsoft.publi c.access
55 microsoft.publi c.access.formsp rogramming
54 microsoft.publi c.access.querie s
45 comp.databases
44 comp.database.m s-access
28 comp.databases. ms-sqlserver
27 microsoft.publi c.office.develo per.vba

Top 10 Crossposters
=============== ====

Articles Address
-------- -------

47 "TC" <a@b.c.d>
38 "Steve" <sa****@penn.co m>
36 "Bruce M. Thompson" <bthmpson@big_N OSPAM_foot.com>
29 Pieter Linden <pi********@hot mail.com>
27 "Larry Linson" <bo*****@localh ost.not>
27 Bobbak <bo****@ottawa. com>
22 "Wayne Morgan" <co************ *************** @hotmail.com>
22 "HB" <fr*****@telus. net>
20 "Steve" <ss****@bellsou th.net>
19 Tony Toews <tt****@teluspl anet.net>

Nov 12 '05 #1

Subscribe Reply

1874

This is interesting

NB

Nov 12 '05 #2

D P Mellon

See the introduction at:

http://groups.google.com/groups?selm...news.dfncis.de

dp******@hairdr esser.net

Nov 12 '05 #3

Similar topics

3263

RFD: comp.databases.mysql

by: George Augustino | last post by:

REQUEST FOR DISCUSSION (RFD) unmoderated group comp.databases.mysql Newsgroup line: comp.databases.mysql MySQL relational database system discussion group. This is a formal Request For Discussion (RFD) for the creation of a world-wide unmoderated Usenet newsgroup comp.databases.mysql. This is not a Call for Votes (CFV); you cannot vote at this time. Procedural details are below.

PHP

2186

Vote on comp.databases.postgresql

by: Otis Green | last post by:

Vote for or against a new newsgroup proposal. To summarize what you need to do, just send an empty e-mail to postgresql-ballot@netagw.com You will receive a ballot by e-mail. Follow the instructions and vote. _______________________________________________________________________ FIRST CALL FOR VOTES (of 2)

PHP

2689

2nd RFD: comp.databases.mysql

by: William Drew | last post by:

REQUEST FOR DISCUSSION (RFD) unmoderated group comp.databases.mysql This is an invitation to discuss the following proposal to create newsgroup comp.databases.mysql. Please note that YOU CANNOT VOTE NOW; you may be able to vote on a version of this proposal later. See the PROCEDURE section below if you need information about how the discussion works. PLEASE POST ANY FOLLOWUPS TO THE NEWSGROUP NEWS.GROUPS.

PHP

2089

Statistics for comp.databases.oracle.server - WE 02/29/2004

by: Mark Townsend | last post by:

Following is a summary of articles spanning a 7 day period, beginning at 23 Feb 2004 05:29:19 GMT and ending at 01 Mar 2004 04:12:14 GMT. Notes ===== - A line in the body of a post is considered to be original if it does *not* match the regular expression /^\s{0,3}(?:>|:|\S+>|\+\+)/. - All text after the last cut line (/^-- $/) in the body is

Oracle Database

1640

2nd CFV: comp.databases.etl

by: Cara | last post by:

LAST CALL FOR VOTES (of 2) unmoderated group comp.databases.etl Newsgroups line: comp.databases.etl Extraction, transformation, loading issues. Votes must be received by 23:59:59 UTC, 12 Dec 2003. This vote is being conducted by a neutral third party. Questions about the proposed group should be directed to the proponent.

Microsoft SQL Server

2295

RFD: comp.databases.etl

by: Cara Altman | last post by:

REQUEST FOR DISCUSSION (RFD) unmoderated group comp.databases.etl This is a formal Request For Discussion (RFD) for the creation of a world-wide unmoderated Usenet newsgroup comp.databases.etl. This is not a Call for Votes (CFV); you cannot vote at this time. Procedural details are below.

.NET Framework

2901

RFD: comp.databases.postgresql.general

by: Andy | last post by:

Someone posted this official proposal to create comp.databases.postgresql.general again. He wrote his own charter. As far as I know, he did not consult any of the postgresql groups first. There may be an upcoming vote on this, so please stay informed and read news.newgroups.announce for updates. Also see message <2uu44nF2eodc0U1@uni-berlin.de> for an example of the proponent's temperament.

PostgreSQL Database

3556

Statistics IO logical reads sometimes 15 million and other times down to 90 thousand?

by: serge | last post by:

I am running a query in SQL 2000 SP4, Windows 2000 Server that is not being shared with any other users or any sql connections users. The db involves a lot of tables, JOINs, LEFT JOINs, UNIONS etc... Ok it's not a pretty code and my job is to make it better. But for now one thing I would like to understand with your help is why the same SP on the same server and everything the same without me changing anything at all in terms of SQL...

Microsoft SQL Server

2315

Automatic statistics update

by: Chris Weston | last post by:

Hi. I have automatic statistic update turned on for all my databases. Is this an overhead I can do without? Could I update them overnight when the database is hardly in use? Thanks -- Chris Weston

Microsoft SQL Server

1431

Excel and MS SQL Server...Calculations for statistics

by: integra18 | last post by:

I hope there are some experts that have good advice here. I have been trying to develop a website for the better part of a year now. I'm having a lot of trouble developing a database that will serve the purpose I need. The site I am designing is a lottery related website. I'm using Community Server 2007 for the forums and other main areas of the site. I also intend on adding several previous results database archives where members will be...

Microsoft SQL Server

9538

What is ONU?

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...

General

10123

Problem With Comparison Operator <=> in G++

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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9975

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

9788

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

8794

AI Job Threat for Devs

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...

Career Advice

7342

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

5384

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3889

transfer the data from one system to another through ip address

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

C# / C Sharp

2765

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General