In short:
In a Access FE with a MS SQL BE, I need to create a folder and several sub folders on a drive. I'm looking for the shortest possible way.
Details: A database that is used to control a production line, needs to save a file in a specified path. Later, these files will be used by mechanical machines (Lathe, etc) to manufacture parts & components.
Now my question:
Instead of creating each sub folder one by one, is there any other way to create all of the path in one go? for example something like this:
And all the necessary folders have been created.
I don't care if it's not a FSO or anything else. Whatever that gives me the result can be a solution.
thank you.
In a Access FE with a MS SQL BE, I need to create a folder and several sub folders on a drive. I'm looking for the shortest possible way.
Details: A database that is used to control a production line, needs to save a file in a specified path. Later, these files will be used by mechanical machines (Lathe, etc) to manufacture parts & components.
- The path will be decided by a sub when a user clicks a button in a form.
This path would be something like :
G:\shop1\Lath2\Nc\FDE\Part1\Section1\Tera\data.nc - This path would be destroyed(deleted) after the machines have done their job. So each time they are different and should be created.
- At present I split the path and read each sub folder and create them one by one with FSO.CreateFolder
- In some cases, because of the structure of the machines or their OS, Production situation, Person in charge or a lot more conditions, the path may be much longer.
Now my question:
Instead of creating each sub folder one by one, is there any other way to create all of the path in one go? for example something like this:
Code:
TargetPath="G:\shop1\Lath2\Nc\FDE\Part1\Section1\Tera\data.nc"
FSO.CreateFolder(TargetPath)
I don't care if it's not a FSO or anything else. Whatever that gives me the result can be a solution.
thank you.
Last edited: