S
Stephen
Hi,
My hands on experience with Access is very limited. I have worked with SQL
Server. I appreciate all the help this group has given me. I am not able to
figure out the answer regarding storing Image in a "Streamed" format.
As I have already posted that I have written a sample application using both
Sql and OleDb adapters to retrieve/insert an image (in stream format) for
SQL Server (the field name is: img_data and the format of this field is:
Image). The data that's stored in this field is:
0xFFD8FFE000104A46494600010101004800480000FFDB004300080606070605080707070909
080A0C140D0C0B0B0C1912130F141D1A1F1E1D1A1C1C20242E2720222C231C1C2837292C3031
3434341F27393D38323C2E333432FFDB0043010909090C0B0C180D0D1832211C213232323232
3232323232323232323232323232
The problem is I have to store the same piece of information in an access
database. I am not able to firgure out what would be the "field format" in
Access that is equivalent to the SQL field format for Image.
Please advice,
Stephen.
My hands on experience with Access is very limited. I have worked with SQL
Server. I appreciate all the help this group has given me. I am not able to
figure out the answer regarding storing Image in a "Streamed" format.
As I have already posted that I have written a sample application using both
Sql and OleDb adapters to retrieve/insert an image (in stream format) for
SQL Server (the field name is: img_data and the format of this field is:
Image). The data that's stored in this field is:
0xFFD8FFE000104A46494600010101004800480000FFDB004300080606070605080707070909
080A0C140D0C0B0B0C1912130F141D1A1F1E1D1A1C1C20242E2720222C231C1C2837292C3031
3434341F27393D38323C2E333432FFDB0043010909090C0B0C180D0D1832211C213232323232
3232323232323232323232323232
The problem is I have to store the same piece of information in an access
database. I am not able to firgure out what would be the "field format" in
Access that is equivalent to the SQL field format for Image.
Please advice,
Stephen.