Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pyrrhus_finch
Yak Posting Veteran
51 Posts |
 Posted - 2005-01-26 : 17:59:45
|
| Dear Friends,How can i upload a file in to Access from an Access Input form. I am not using any kind of web server - and need to use Access alone.I need to have a form button to upload attachment and a place to list them - Ideally the upload would copy the desired files into a file directory with the record_id as a file name prefix and not exist as a clunky binary in the DB.Any ideas how?Examples out there?Rescources / documentation available?Thanks a whole lot! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-01-26 : 20:52:52
|
| When you say "upload", are the people doing the upload on the same network as the Access database? If they are, you can use a little VB to call the Shell() function to copy the file to the proper folder.I think there may also be some functions to create the file browsing window. If it's not built-in to VBA or Access it's a pretty easy Win32 API call. Take a look here:http://www.mvps.org/access/That is probably the best site for advanced Access stuff. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-01-26 : 20:53:50
|
| ROFL, I click on the site, go to the API link, and what is the FIRST entry on the list?http://www.mvps.org/access/api/api0001.htm |
|
|
|
pyrrhus_finch
Yak Posting Veteran
51 Posts |
Posted - 2005-01-27 : 12:28:01
|
| Thanks, I will take a look.Yes, they will upload files from their workstation or network drive to be saved /"uploaded" to a restriced folder on the network drive. |
|
|
|
|
|
|
Upload file in and Access form