Opinions on Access & Word interaction

[Zorro1265]

Heres the problem. I have an access database with 7000 records with new ones being added daily. I also have about 15000 or more microsoft word documents. I would like to have all these things searchable and viewable from one search screen. I have been trying to find out how to import all the word files but havent had many ideas on how to do it. What would you do if it were your project?

 

[JerryDennison]

You could do this a couple of ways. If you expect the word files to be dynamic you probably wouldn't want to setup a table and add them as records. But rather, setup an array that goes and grabs the document names and then use the array to allow the user to select then launch that document. The alternative would be to load the document names into a table as OLE objects which then could be searched and launched a little more easily but would be more difficult to manage.