Document Database

[jprescottjr]

I was wondering if anyone can point me in a direction on how to create a Document Database using Access. I am a database newby, but this would be something of graet use to our company. Nay help would be great.

Thanks.

 

[acent]

A few things come to mind...

1. You could store the documents in the database, though this is NOT reccommended.

2. Another way is to store a table of filenames, and a directory of files. Then when a user wants a file, you have the database open that file (via VBA) for the useres. This assums all your users have the required software to open the file.

3. Finally, if all the documents are simple text, you could have a table store the words and essentially have the database build the documents into reports for your users. I know I'm not explaining this option very well.

Hope one of these might work for you.

"If you say you can, or you say you can't, you're right!"
-- Henry Ford

 

[fneily]

Or you could store all your documents in the same folder(s) and then have a listbox(s) on a form that would display their names and when selected would open the file. Here's sample code to build the listbox:
Private Sub Form_Load()
Dim LoadFiles As String
Dim strFill As String
LoadFiles = Dir$("c:\dev\*.*")
Do While LoadFiles > ""
strFill = strFill & LoadFiles & ";"
LoadFiles = Dir$
Loop
lstFiles.RowSource = strFill
End Sub

Or, you could build a Windows Explorer lookalike, called a treeview:

http://msdn.microsoft.com/library/?url=/library/en-us/dnsmart04/html/sa04k6.asp

http://www.mvps.org/access/api/index.html