Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Adding Attachments to forms 1
- Thread starter Yardyy
- Start date
belovedcej
Programmer
What I do is provide a table that contains a field of hyperlinks. Then the user can copy and paste the Windows address of the file or folder into the field in the database, and it's linked. Prevents you from having to store the file itself and bloating your table, and accomplishes the same thing.
-
1
- #3
Using a blob field in an Access database to store a file such as a JPG, PDF or DOC is going to increase the size of your database quite substantially.
With the file size limit of 2Gb for an MDB file this could be reached quite quickly if you have a lot of records.
A better way is to store the path to a file in a text field, then actually save them in a network shared folder so all the database contains is a field in a table containing something like \\Server\MyApp\Files\Somefile.txt
You then have a button that uses ShellExecute to open the file with whatever the default app is to handle that particular file format.
John
With the file size limit of 2Gb for an MDB file this could be reached quite quickly if you have a lot of records.
A better way is to store the path to a file in a text field, then actually save them in a network shared folder so all the database contains is a field in a table containing something like \\Server\MyApp\Files\Somefile.txt
You then have a button that uses ShellExecute to open the file with whatever the default app is to handle that particular file format.
John
- Thread starter
- #4
Both sound very good, i wasnt aware of the 2GB limit, thanks.. how would i go about storing the hyperlinks to a text field, got to make this as easy as possible. I like the idea of a network share, so when the user next time goes to the record and clicks the attachment the file should open in the default application.. sounds good
Many Thanks
Yurov Ardyy
Many Thanks
Yurov Ardyy
See:
Attach files and graphics to the records in your database
This is for Access 2007
Attach files and graphics to the records in your database
This is for Access 2007
- Thread starter
- #7
Hi, jbarnett how would i go about acieving this
"A better way is to store the path to a file in a text field, then actually save them in a network shared folder so all the database contains is a field in a table containing something like \\Server\MyApp\Files\Somefile.txt
You then have a button that uses ShellExecute to open the file with whatever the default app is to handle that particular file format."
sounds like this would suffice for my situation.
Many Thanks
Yurov Ardyy
"A better way is to store the path to a file in a text field, then actually save them in a network shared folder so all the database contains is a field in a table containing something like \\Server\MyApp\Files\Somefile.txt
You then have a button that uses ShellExecute to open the file with whatever the default app is to handle that particular file format."
sounds like this would suffice for my situation.
Many Thanks
Yurov Ardyy
Add a text field to your table to indicate the path to that file.
Add a textbox on any forms bound to this field.
You can then populate this field with the paths to the files as necessary.
As Remou says, using FollowHyperlink is an easier way than using ShellExecute to open a registered file with its application.
John
Add a textbox on any forms bound to this field.
You can then populate this field with the paths to the files as necessary.
As Remou says, using FollowHyperlink is an easier way than using ShellExecute to open a registered file with its application.
John
- Thread starter
- #10
- Status
Similar threads
