Is it possible to create folder in Access?

[musa.biralo]

Hello there,

I am wondering if i can create a folder and import some dbf file
inside the mdb file... For example

Folder Level 0 (Import files and folder inside this level)

File 0.1.dbf
File0.2.dbf

Folder Level 0.1
File 0.1.1.dbf
File 0.1.2.dbf
File 0.1.3.dbf

Folder Level 0.2
File 0.2.1.dbf
File 0.2.2.dbf

Folder Level 0.3
file 0.3.1.dbf

If not will be able to do something (like create a logfile and put the
information there?

Any idea, brainstorm, any link, any way will be great!!!
Thanks
Musa.Biralo

 

[Ken Snell MVP]

See MkDir and Name statements in VBA Help.

 

[musa.biralo]

Thanks for the suggestion, Ken and sorry for not making myself clear.
I want to create folder(s) or similar inside the Access (inside the
mdb file) not in the harddrive.

musa.

 

[John W. Vinson]

Thanks for the suggestion, Ken and sorry for not making myself clear.
I want to create folder(s) or similar inside the Access (inside the
mdb file) not in the harddrive.

Not to my knowledge. A relational database and a file system have some common
features but they are NOT the same; an Access Table (unlike a dbf file) is NOT
a file, but rather a composite logical construct stored in multiple places
within the (proprietary and unpublished) JET file.

 

[Philip Herlihy]

Thanks for the suggestion, Ken and sorry for not making myself clear.
I want to create folder(s) or similar inside the Access (inside the
mdb file) not in the harddrive.

musa.

I think you're making the classic (understandable) mistake of explaining
what you want in inappropriate technical terms. Access just doesn't
work this way. If you let us know what you want to achieve in the real
world by doing this, the chances are we'll recognise it and be able to
point you in the right direction. So, what information are you
recording, and what "structure" do you want to represent? What are you
"describing"?

Here's a favourite couple of links which explain how Access structures
things, and there are very few situations which can't be handled this way.
http://www.lynda.com/home/Player.aspx?lpk4=31001
http://office.microsoft.com/trainin...ID=RC061183261033&CTT=6&Origin=RP061494301033

Phil, London