On Tue, 29 May 2007 09:29:27 -0400, "Michael Kintner"
<nospam@nospam.comwrote:
Yes that helps, because it eliminates the new Attachements feature in
A2007 from consideration.
Typically you want to store documents in the file system. Your app
would have a "root" folder option, and the files are below that root.
Sometimes they can all be stored in one folder, sometimes you want to
create a folder tree. That's more useful for humans than for programs.
Your app would also have a table with filenames, 1 to many to the main
table. E.g. if these were files about orders, you would create
tblOrderFiles:
FileID (auto, PK)
OrderID (required; link to tblOrders.OrderID)
FileName (required)
Then you write queries to select, add, delete from this table.
Then a form that uses these queries to show the files in the table,
allows the user to manipulate them (e.g. Add, Delete), and view them.
View I would do using the ShellExecute API
(
http://www.mvps.org/access/api/api0018.htm)
-Tom.
Quote:
>I am looking for add-on tools or code to allow me to attach scanned PDF
>documents to a database record.
>
>I would like to know if there are developer tools out there that can do the
>following:
>- Appending muliple as in many PDF docs to a specific record.
>- Or maybe I create a folder and the AccessDB reads the contents of the
>folder showing the files related to the specific record.
>
>Kinda like a achive file manger of related files to a database record.
>
>Note: Eventually this access database will be pushed to SQL server if that
>helps.
>
>Can anybody help me with this?
>
>Thank you in advance.
>Michael Kintner
>
|
