Search results

So a question. Was it necessary to do the c1 alias in the creation of the 2nd sql statement, or was that a convenience to aid in the readability of the code? I'm just trying to understand if the SQL alias in the first statement construction could NOT be reused during the SQL statement second...

Wow. Your code worked perfectly on the first go. I clearly have much more to learn in the land of SQL. Thank you very much for the help.

Thanks for all the help. I'm close to completing the update to my db, but I've a snag when trying to work with sql. Per the recommendations found in this thread, I've done some testing and have gotten to the point where a LEFT JOIN query accomplishes the task of showing all records in the main...

Cool. I have a bit of sophistication in my code (If statements to detect specific directories and excluding certain conditions), but perhaps I could simplify things a bit using your method. It may be another option to speed up the process.

Correct. I'm using a recursive directory function on about 25TB of miscellaneous drives and directories. The frequency I run this function is perhaps every couple of weeks. the Database is essentially a personal multimedia catalog that I want to maintain as "current" relative to deletions...

Wow. Thanks for the replies. I now have quite a bit to work with and some new ideas to try. I'll try to report back as I develop the solution...

@jdraw Thanks for the video link. I'll be sure to check it out.

Yes, fldLocation is indexed, No Duplicates

Thanks for the reply. Taking a step back, the core purpose of my database is to catalog different files on my computer. I start out by scanning specific directories and building a dictionary of all found files (I used to use a Collection for these found files, but the dictionary runs much...

I'm looking for the fastest way to update a table boolean field in an access table by way of VBA. A snipet of my code is below For Each vFile In dictClipsDB.Keys If Not dictFilesFound.Exists(vFile) Then strSql = "UPDATE tblClips SET blnAlive = FALSE WHERE fldLocation = " &...