Hi
My problem is that i need to store a large amount of images in the database one way or another. Potentially each item from the item table can have an associated image.
I have currently embedding the image as a OLE in the field which is working great but will not be along term solution due to the size.
I can't just link because there are 2 users who replicate they're version to the server (the reps on the road) and they are the ones who input the image.
What am thinking of doing is having a folder on the server which contains all the images. Then having the rep simply add the file name of the image to the field in the DB. Then have a button which opens the predetermined filepath on the server + the filename from the field.
Does this make sense? Any hints on the code for the button.
basically a button which will open a file from a predetermined folder on the server but gets the file name from the field in the current record.
Cheers
My problem is that i need to store a large amount of images in the database one way or another. Potentially each item from the item table can have an associated image.
I have currently embedding the image as a OLE in the field which is working great but will not be along term solution due to the size.
I can't just link because there are 2 users who replicate they're version to the server (the reps on the road) and they are the ones who input the image.
What am thinking of doing is having a folder on the server which contains all the images. Then having the rep simply add the file name of the image to the field in the DB. Then have a button which opens the predetermined filepath on the server + the filename from the field.
Does this make sense? Any hints on the code for the button.
basically a button which will open a file from a predetermined folder on the server but gets the file name from the field in the current record.
Cheers