PTNL
03-25-2008, 08:48 AM
I have a client that is using an Access 2003 form as the front-end interface for their SQL Server 2005 database. All data is stored within the SS2005 database, and Access is just the user interface.
The problem they are running into is with the "Image" column that holds a file. The Access 2003 form is using a bound field for inserting the data, and is adding in the extra OLE headers to each file.
What they want is to have the following:
1 - Extract all of the original files from the "OLE Object" data to the file system.
2 - Add a control to the Access 2003 form that will do file writes to the SS2005 database, but with the file contents in the "image" column and the filename in the newly-added "varchar" column.
Related thoughts:
For #1.... From various Google-ing, I've learned that this is not an easy feat if you're trying to extract something other than an image file (gif, jpg, bmp, etc.). Something about adding a binary offset to skip past the "ole header". I did find a possible solution here, but my current post count in the message boards does not allow me to send a direct link. You can find the options I am looking at by searching on Google-Groups for the following string:
"pdf ole header access" (w/o quotes)
For #2.... Is it even possible for an Access 2003 form to upload a normal BLOB without the extra OLE information? If so, any links on doing a file upload without OLE info getting added is appreciated.
Additionally, I'll have some extra steps that will need to be done. Notably reading the PDF's individually and writing the BLOB's and filenames to the SS2005 database. But I can accomplish this easily with some DotNet code.
This is my first post to the VBA Express community, and it probably won't be the last :) I'm looking forward to everyone's thoughts on these issues.
TIA !!!
The problem they are running into is with the "Image" column that holds a file. The Access 2003 form is using a bound field for inserting the data, and is adding in the extra OLE headers to each file.
What they want is to have the following:
1 - Extract all of the original files from the "OLE Object" data to the file system.
2 - Add a control to the Access 2003 form that will do file writes to the SS2005 database, but with the file contents in the "image" column and the filename in the newly-added "varchar" column.
Related thoughts:
For #1.... From various Google-ing, I've learned that this is not an easy feat if you're trying to extract something other than an image file (gif, jpg, bmp, etc.). Something about adding a binary offset to skip past the "ole header". I did find a possible solution here, but my current post count in the message boards does not allow me to send a direct link. You can find the options I am looking at by searching on Google-Groups for the following string:
"pdf ole header access" (w/o quotes)
For #2.... Is it even possible for an Access 2003 form to upload a normal BLOB without the extra OLE information? If so, any links on doing a file upload without OLE info getting added is appreciated.
Additionally, I'll have some extra steps that will need to be done. Notably reading the PDF's individually and writing the BLOB's and filenames to the SS2005 database. But I can accomplish this easily with some DotNet code.
This is my first post to the VBA Express community, and it probably won't be the last :) I'm looking forward to everyone's thoughts on these issues.
TIA !!!