Replies

What 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?

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

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

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

That 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?

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

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

Sorry can’t help. I normally keep downloaded .exe’s, but I can’t find an older version of it on my machine.

Off 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

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

Actually #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

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

By 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)

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

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