"I think this is where things like MS Acces / Fox Pro / Lightswitch etc are excellent."

Ditto, couple Excel to Access and most of these problems disappear.

I have to partially take back what I said about everything working because for some reason the scan doesn't go through all the folders. I know this because I couldn't...

Thank you so much, you were right, now everything works and here's the complete code below, a couple of considerations: at the end of the whole scan I get the...

Hi again, thank you, I'll only be able to test your code tomorrow on a password-protected mdb. I hope I'm wrong but don't you think that since your latest code...

Thank you, still no can do. Following your latest advice, the code is now

Sub ProcessDatabase(ByVal strPath As String)

Dim vbc As VBIDE.VBComponent, objConnection As ADODB.Connection, strConnection As...

You're right, I get no error. How do I query for a list of tables within the objConnection object?

Thank you, if you look at

app.OpenCurrentDatabase strPath, , ""

you can see the password argument is indeed filled, just by a zero-length password

Unfortunately, even by using the code you see below, whenever the loop encounters a password-protected mdb, the dialog box asking for the password still comes up, any other workarounds?

Private Function...

Thank you so much, it definitely runs without a hitch but I'll be able to test it against password-protected mdb's only on Monday so I'll let you know then.

Thanks, what's the code to do that? I'm looping through all the folders on my pc's hard drive.

Hi Wendell, about the third option Storing images in Access Databases:

In Mark Andrews' reply,

Set RSAttachments = rs.Fields("Attachments").Value

to me sets RSAttachments to be the value of the Attachments field so

how...

I'm well versed in Access but know very little T-SQL. What does "ROW_NUMBER() over(partition by" do?

Thanks Candide, in your VBA procedure you have the line:

strSQL = "SELECT dbo.udf_GetStuff (44, 22) AS retVal"

What's the code behind udf_GetStuff?

By the way, why isn't the hexadecimal colour code accepted?

if dbo is the schema owner, I don't think in Access you can call the udf_GetStuff function using the syntax

dbo.udf_GetStuff

What does dbo represent in the example you're using?