Create a directory for entries in MS Access 2007

Question

Is it possible to create a directory folder for individual entries in Access 2007. For example

tblUser
ID
firstName
surName

When adding an entry, create the folder C: \ userdatabase \ Surname, firstName, ID

It may seem that this is useful in situations, for example, when a large number of images / files should be associated with the recording. Access will create and link to the directory for each entry.

Thanks in advance for any advice.

Noel

Answer 1

You can use the VBA MkDir statement to create a directory.

, , , , , :

MkDir CurrentProject.Path & "\" & ID

Answer 2

:

Answer 3

, , , . , , .

, , , , ( ).

, , , . , , - , .