-
WSDrew
AskWoody LoungerJanuary 24, 2003 at 7:20 pm in reply to: Using Class modules for a fragmented data structur (Access 97 and up) #647642What I meant by that, is that not everyone that works with Access knows what Normal Form is. If you say that term to someone who uses/develops in Access, but does not know the meaning from relational theory, they are probably going to think you are talking about a Form, and not a data structure. That’s why I used the term fragmented data structure, since that describes higher levels of Normal Form.
Does that make sense?
-
WSDrew
AskWoody LoungerJanuary 24, 2003 at 6:46 pm in reply to: Using Class modules for a fragmented data structur (Access 97 and up) #647628Correct, the ‘industry’ term is Normal Form. However, I figured that fragmented sounds clearer then NF. I wouldn’t refer to a tuple, I would say field. (Even though field is an industry term, the relational term is tuple.
I had been developing Access databases for a while before I had even heard of Normal Form. I had been using the ‘theory’, just didn’t know the industry terminology.
-
WSDrew
AskWoody LoungerJust took a look at it. It’s not really a collection object on steriods. In fact, the only advantage I see is the .Exists method, which is simple to check by way of erroring with a collection. The RemoveAll method is a waste, with a collection you just set the object to a new collection. It is more like an Array on steriods, because you cannot use a For Each statement, you are still looping it like an array. Also, you don’t have the sorting. When you add an object, you can’t place it before or after an object, only at the end.
With a collection, you can continuously add items. If you want them sorted by their index, by some property, you just have to do a simple for Each loop until you reach the object your new object should be placed before. Then use that object’s key to place your new object before it. Now ‘reindexing’ everything, the collection handles that all on it’s own. By making it easy to sort by index, you are getting dual sort capabilities. The objects can be ‘retrieved’ in the correct index sort order with a For Next, and they can be retrieved in the correct key sort order by using a for i=1 to MyCollection.Count loop. (Assuming your keys are alphanumeric).
-
WSDrew
AskWoody LoungerA collection is not a ‘data structure’. It is a collection (for lack of a better word). A collection is like an array, but far more flexible.
For instance, with an array, it has a fixed size. You can change the size by using Redim, but you have to do that manually. For a collection, you simply use .Add and .Remove. You can get the number of objects in a collection with it’s .Count property.
A collection also lets you use a For each statement. It also allows for easy sorting. (When you Add an object, it can be added before or after another object. You can also refer to an object in a collection by either it’s index (1 based), or by it’s ID (something you can define when you add an object).
I have posted an Access database with a complex data structure, that uses Classes and Collections in the Access section of the lounge. If you want to see a collection at work, take a look at that.
-
WSDrew
AskWoody LoungerThat is what I found curious. I built a listbox from code, and hitting the delete key did nothing. Are you capturing the key press event, to capture the delete key being pressed?
-
WSDrew
AskWoody LoungerI didn’t realize that you could use collections inside VBScript. Go figure. Guess my MSDN is a little out of date.
It seems that you can’t use Collections though (at least not user defined)….that is true, correct?
Sort of takes the kick out of being about to create a class.
-
WSDrew
AskWoody LoungerDo you mean a Class within ASP? I didn’t think, in fact I am pretty sure ASP won’t let you build a class within the script (at least when using VBScript). I have a VB ActiveX .dll, which IS a set of two classes, which builds from the same information. If you want, I can send it to you. I actually wrote the VB version first, because we host our own site (I host my own site at home too), so I have direct access to the webserver, therefore it’s a snap to use custom ActiveX .dll’s. I have seen hosting companies allow their use also, but not every hosting company does that.
I wrote the ASP version so that it works as long as ASP is available….no ActiveX required, but since VBScript doesn’t let you build classes or collections, I had to use arrays.
-
WSDrew
AskWoody LoungerSorry can’t help. I normally keep downloaded .exe’s, but I can’t find an older version of it on my machine.
-
WSDrew
AskWoody LoungerOff the top of my head I don’t know the command for not removing the email off of the server. In fact, I thought that it was a direct command TO delete the email from the server. When you list the emails, you should be sending an email ‘id’ through. That is what OE is using to determine if it has gotten that email before. On an exchange server, a message’s ID is a 255 character key, so it allows for an impossibly immense number of emails to be stored before it would have to reuse a ‘key’.
So OE determines what’s been read or not (it keeps track), not the server.
Drew
-
WSDrew
AskWoody LoungerAlso, if the LAN connection uses a Proxy. Keep a check mark in the ‘Automatically Detect Proxy’ option, because if you have a proxy setup, the dialup connection will try to use the LAN proxy, which it will probably not be able to get too.
-
WSDrew
AskWoody LoungerActually #3 isn’t entirely true. If you have access to your IIS server, you can set any file extension you want to be ‘read’ by the asp engine. (I don’t know if hosting companies let you do that or not….but it is possible.).
Drew
-
WSDrew
AskWoody LoungerYou can very easily ‘view’ and even edit the navigation from FrontPage itself (through VBA code), so you can create a ‘macro’ to update your site. However, I just recently posted an ASP script that builds a sitemap page from the FrontPages ‘navigation’ data file. It’s not that hard to crack, it’s just a comma seperated text file. (structure.cnf) (I think the folder is ‘_pvt’….heading home, don’t feel like looking it up. But I posted about it in the FP section (Dynamic Site Map). I also posted a VB ActiveX .dll that does the same thing (I think nicer….), but it requires that you can register an ActiveX on your host site.
Give me a holler if you have any questions on my .asp code.
-
WSDrew
AskWoody LoungerBy default the IIS ‘default user’ should have permissions set already. However, one thing that I see overlooked in the posts so far, is that your URL’s are only going to folder level. You have to setup a ‘default’ document to do that.
Get into the IIS Admin window. Right click on the ‘root’ folder, and click properties. The tab you want is documents, which will list the ‘default’ documents that the IIS server looks for, when a direct page is not requested.
You can test what I just brought up without even going into IIS’s settings. Just try pulling up the page with the FULL URL, which includes the page. (ie, http://MyComputer/index.htm)
-
WSDrew
AskWoody LoungerI’ve run grokster in the past. It’s not bad. One of the neat tricks is that it will download from multiple sources, and plug it all together at the end. (Handy if you have a quick download, and are pulling from a bunch of slow connections).
I’ve installed it here and there, and all I can recommend is that after the install, WIPE OUT Gator, and anything other ‘installations’ that appear. Grokster runs fine without them, it just installs them when it is installed (OR WHEN IT IS UPGRADED). (I think there is a Grokster ‘add’ program, I left it alone. I kicks a few popups up, but only when Grokster first loads.) I run ZoneAlarm to prevent anything else from happening…that is something I also recommend doing….my hits on Zone Alarm go up drastically when I’m logged into Grokster.
-
WSDrew
AskWoody LoungerActually, Windows 2000 comes with it’s own file shredder. Not as easy as a click, but a lot more educational!
From your Windows 2000 CD, install the support tools. (Don’t remember what folder their in, probably support, the help files should tell you.)
One of the tools that is added is DiskProbe. It will let you read and write to your harddrive BIT BY BIT. If that doesn’t let you ‘shred’ your files, I don’t know what will.
On a side not, I goofed a partition once, and I found a nifty utility called Restore2000 Pro, which will ‘scan’ an NT partition for ANY file(s)/folder(s). It doesn’t even have to be a partition, it could be a partitionless drive, the files just have to be saved in NTFS format.
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Backing up Google Calendar
by
CWBillow
4 hours, 20 minutes ago -
Windows 11 Insider Preview build 27818 released to Canary
by
joep517
16 hours, 58 minutes ago -
File Naming Conventions (including Folders)
by
Magic66
31 minutes ago -
Windows 11 Insider Preview Build 26100.3613 (24H2) released to Release Preview
by
joep517
1 day ago -
Microsoft sends emails to Windows 10 users about EOS
by
Alex5723
10 hours, 54 minutes ago -
Outlook 2024 importing Calendar and Contacts – FAILURE
by
Kathy Stevens
1 hour, 8 minutes ago -
Adding Microsoft Account.
by
DaveBRenn
1 day, 1 hour ago -
Windows 11 Insider Preview build 26120.3576 released to DEV and BETA
by
joep517
2 days, 1 hour ago -
Windows 11 Insider Preview Build 22635.5090 (23H2) released to BETA
by
joep517
2 days, 1 hour ago -
Windows 11 won’t boot
by
goducks25
2 days, 15 hours ago -
Choosing virtual machine product for Windows on Mac
by
peterb
1 day, 15 hours ago -
Rest in Peace
by
Roy Lasris
2 days, 19 hours ago -
CISA : Install Windows March 2025 Updates until April 1 or shut down PC.
by
Alex5723
2 days, 19 hours ago -
Google proposes users with incompatible Win 11 PCs to migrate to ChromeOS Flex
by
Alex5723
2 days, 20 hours ago -
Drivers for Epson Perfection V600 Photo – scanner
by
Bookman
2 days, 1 hour ago -
Long Time Member
by
jackpet
2 days, 23 hours ago -
Woody Leonhard (1951–2025)
by
Will Fastie
17 hours, 2 minutes ago -
What I learned from Woody Leonhard
by
B. Livingston
2 days, 16 hours ago -
Windows Settings today
by
Simon Bisson
3 days, 7 hours ago -
Mail Merge magic in Microsoft Word
by
Peter Deegan
5 hours, 21 minutes ago -
Businesses in the crosshairs
by
Susan Bradley
1 day, 21 hours ago -
Double-row taskbar?
by
CWBillow
12 hours, 53 minutes ago -
Upgrading non-supported HW to Win 11
by
RetiredGeek
22 hours, 28 minutes ago -
Audio locks up after 15 minutes
by
WSArthurR
21 hours, 58 minutes ago -
Copilot app uninstalled
by
Susan Bradley
20 hours, 10 minutes ago -
Strongbox Password Manager Sold to Applause Group – Cost Escalation Imminent
by
Paul T
4 days, 17 hours ago -
SharePoint
by
CBFPD-Chief115
3 days, 15 hours ago -
Google replacing Google Assistant with Gemini AI assistant
by
Alex5723
4 days, 19 hours ago -
You can no longer stop Alexa from sending voice recordings to Amazon
by
Alex5723
4 days, 20 hours ago -
Meeting Woody in person
by
Susan Bradley
18 hours, 33 minutes ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.