[AccessD] Running Dir from Batch file in MSAccess

[Jim Lawrence]

Jack:

I have always viewed Access as just a great graphic front end for any application. Its true beauty is in its capability to connect to virtually any source. Its batch file shell, alternative data sources, mail, web and internet access is just the start. I was always a lazy programmers so anything I could hack together, code I could steal, rather than build, was always a plus. I think MS Access was built for guys like me.

OTOH, it is best, where at all possible, to assemble batch files internally and write them out and then run them...stops potential of batch file corruption. For me, "simple" generally translates into "reliable".

Another note: In my opinion, it is always better (much faster uploads especially when thousands of mixed graphics are being used) to store a JPG file externally, in its own directories and then call it from the application rather than store the graphic in a DB.

OTOH, if the person you are working with needs to go with a pure Access solution...

Jim    

----- Original Message -----
From: "jack drawbridge" <jackandpat.d at gmail.com>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Sunday, March 12, 2017 1:08:47 PM
Subject: [AccessD] Running Dir from Batch file in MSAccess

Jim,

I was trying to respond and say I agree that its a fast method. However,
the person I'm trying to help is not familiar with vba.
I got a flag on your email saying it is marked as spam??
So I'm starting again.

I am not  experienced with Bat file from Access. I have had no luck with
google nor the forums I participate in.

I was trying to get a list of image files (jpg) and felt a simple Access
form with a Shell cmd would hide most everything.

But as always Simple has various meanings!!!

jack
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com