Attaching a file in Access 1

[napa1m]

Hi, and thanks in advance for any replies/responses.

I would like to attach a file in Access, but don't know how to code it. Basically, this is what I would like to happen:
1. The user would click on a button.
2. A "Locate File" prompt would open and the user would locate the file on one of the drives
(exactly like the one used in Internet Explorer to "Open" a file, for example).
3. On the click of "OK", the database would automatically Copy the File, Paste it in a subdirectory of the database
(Ie. C:\(Database Path)\Attached Files),
and make a reference to the file in a table.

I hope you understand what I mean...
...post if you dont. Napalm2000
hlechler@hotmail.com

http://www.napalm2000.com

 

[Francescina]

This should be quite easy if you just use the FileSystem object commands.
Alternatively you could integrate these files into the table structure. There are several wizards available (JPGs, Word, Excel, Autocad...) that do this automatically. Have a look on the "powerup"-links on

http://www.unsoftwareag.com