Recent content by notarat

Hi all! I'm back to request some assistance about a query I am trying to do in MS Access. Lagbolt and Jal (?) provided me with a great deal of assistance last year in http://www.access-programmers.co.uk/forums/showpost.php?p=784302&postcount=1 and now it seems I need some more assistance...

I went ahead and downloaded the AccessEnum.zip program from the MS Tech Net site and I threw a Macro button on a new tab of the database to call it. Now I can pull a listing of all folders and files, listing the Security Group (or groups) that have rights to the fole/folder and what level of...

I was using LS previously, but it didn't give me the information I needed. (Specifically, Owner) I needed that information as well to identify when someone took ownership of a folder structure and the files within away from my Admin group. I do agree though that it is a very nice and fast...

I compact on exit most of the time. Just for informational purposes, it can handle a share drive using over 950Gb of space that contains over 750,000 files. It runs in about 8-9 hours on the big share if I'm not doing anything else on the network like streaming and playing Everquest II and...

Well here's my dumbed down version now that I have completed my work on it (took a holiday for part of December and January) I hope you guys don't mind that I stupified it so my relatives could run it on their machines on their parts of the shared drive. Thanks for all the help!

I'm a bit stumped here so maybe I could get someone to enlighten me. I recently threw together a small MS Access database with a lot of help from Lagbolt and Jal here on the forum. (they rock!) It searches my shared drives and populates a database table with the following information: File...

Thanks Jal! (And Lagbolt!) Just wanted to say that I am now running it on the root level of my share that holds about 550GB of data. Performance-wise, it looks like it'll take 24.9 hours to complete, which is about 3 times longer than my old scanning method. It looks like I'll have to...

Awesome Modification! It went through everything on the first share without any problems. I'm running a comparison right now between the old method and this one to see how fast this scripting pulls the data as compared to the old DOS method. Hmm..."Lagbolt Jal Thomas"...My kid is going to...

OOPS! I forgot to post the wording on the error dialog box: Run-time error '3075' Syntax error(missing operator) in query expression "Syntax error(missing operator) in query expression "Activity POC's.xls','O:\Shared_Documents\langer.family\Documents\Point of Contact\Langer Family', #1/9/2008...

As a quick follow up to my post above, I believe the Syntax error I am receiving with Lagbolt's code (Lagbolt, the coding god. not my son) is due to the code encountering a single quote (possessive) in the filename, such as "Bob's Motorcycle Restoration.ppt". It seems that when it encounters a...

"Lagbolt"...That's going to be a strange name for my first-born, but I think that's what I'll call him after looking at that code ;) I ran it on my Desktop and it looked fantastic! I then ran it on my share drive, and it was looking really good, right up to the point that it errored out...

If I understand you correctly, you're saying that if the structure is very nested and there are a lot of files involved, the script could run out of memory and crash. I'm currently able to grab the data I want from the DOS script. My only complaint with it is that I have to do an inordinate...

I haven't coded in VBA before, so I'd appreciate any help you can provide helping me write the code. Even something as simple(?) as modifying the script I included to just output the results to a CSV file (that I could then macro on my own to be imported) would help me greatly! My current...

Let me follow up by saying I wouldn't mind too terribly if the script I included could be modified to create a CSV file, instead of a spreadsheet. I could live with that, but I would be happiest if I could populate the table straight away rather than use an intermediate step.

Greetings! I just signed up and performed a normal, then advanced search, and combed through the 70+ threads that were returned in the search results. None of them really answered my question, so I am posting in hopes of finding some help. (Either my terms weren't spot-on or the topic hasn't...