Message for Arvin on Doc Mgmt Database

[Guest]

I have come across this document management database and it could be perfect
for what I need.

http://www.datastrat.com/Download/DocMgr_2K.zip

 

[Guest]

cont ....

But what I need to do is create a table for all documents in the folder
excluding the subdirectories.

 

[Arvin Meyer [MVP]]

Traversing the directory structure can only be accomplished by looking into
the subdirectories. You can eliminate the subdirectories by moving the files
into the main directory, and deleting the subdirectories. You can also run
an update query and eliminate the data in the field. For instance:

C:\Projects\CFCS\010607\
and:
C:\Projects\Data\

can be updated to:

C:\Projects\

with something like:

UPDATE TableName SET TableName.Path = Left([Path],12);
--
Arvin Meyer, MCP, MVP
Microsoft Access
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Guest]

I realised the simplest thing would be to use your database and then
transfer the information.

Traversing the directory structure can only be accomplished by looking into
the subdirectories. You can eliminate the subdirectories by moving the files
into the main directory, and deleting the subdirectories. You can also run
an update query and eliminate the data in the field. For instance:

C:\Projects\CFCS\010607\
and:
C:\Projects\Data\

can be updated to:

C:\Projects\

with something like:

UPDATE TableName SET TableName.Path = Left([Path],12);
--
Arvin Meyer, MCP, MVP
Microsoft Access
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

cont ....

But what I need to do is create a table for all documents in the folder
excluding the subdirectories.