• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 214
  • Last Modified:

How can I convert a Binary field to Long binary data?

Hello,

The title says it all...

Please help. Thanks.
0
i950
Asked:
i950
  • 10
  • 9
  • 3
2 Solutions
 
Rey Obrero (Capricorn1)Commented:
is this field in an access table?
0
 
i950Author Commented:
Yes.
0
 
Rey Obrero (Capricorn1)Commented:
you can use

currentdb.execute "alter table NameOfTable alter column binaryfieldname longbinary"

just change  
     NameOfTable  to actual name of table
     binaryfieldname  to actual name of binary field
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
i950Author Commented:
I'm a beginner... where should I run that code?

Thanks.
0
 
Rey Obrero (Capricorn1)Commented:
you can place the codes in a  click of a command button in a form

private sub command0_click()

currentdb.execute "alter table NameOfTable alter column binaryfieldname longbinary"

end sub

do you know how to create button in a form?
what is the name of the table? the name of the field?


0
 
i950Author Commented:
I think I was able to run the code but nothing changed. It still showing "Binary" not "long binary data"

Thanks.
0
 
Rey Obrero (Capricorn1)Commented:
can you post the codes that you use, all of it
0
 
i950Author Commented:
Here it is:

Option Compare Database

Private Sub Option4_Click()

currentdb.execute "alter table ev1 alter column binp longbinary"

End Sub

It's on the Click event or a radio button.
0
 
Rey Obrero (Capricorn1)Commented:
you should see  Ole Object in the data type column when you open the table in design view.

check again.
0
 
i950Author Commented:
I do.. but when I double click the table it's showing "Binary" only.

The reason I want to change it to long binary data is the long binary data is byte by byte the same as the file that was entered in the database. When a file is saved as Binary only, chars are being added at the beginning of the file and when I'm extracting the files it's being corrupted.
0
 
Rey Obrero (Capricorn1)Commented:
The LONGBINARY data field is used to store graphic image data and allows any alphanumeric data to be entered and saved.

don't double click the table.
select the table and click Design from the database objects menu.
now look for the field  {binp } and see what is written in the Data Type column
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Cap ... doesn't sound like the code is executing for him?  I know the code works because I tried it ... changed a Text field to LongBinary and then to Binary.

It's interesting that you can set a field Data Type to Binary in code ... but Binary is not an option as a Data Type to pick in table design view ... but will show as Binary if you set it in code. Also, when you set it to Binary, the Field Size is set to 510 (255*2).  But ... if you try to change the field size to say 500 or 509 or anything less than 510 but greater than 255 ... it won't let you !

i950:  How are you loading the Binary data into that field?

mx
0
 
Rey Obrero (Capricorn1)Commented:
try

Option Compare Database

Private Sub Option4_Click()

currentdb.execute "alter table ev1 alter column binp longbinary"

msgbox "Code was run"         '<--- you should get this message

End Sub
0
 
i950Author Commented:
> don't double click the table.
> select the table and click Design from the database objects menu.
> now look for the field  {binp } and see what is written in the Data Type column

It's written OLE Object

> msgbox "Code was run"         '<--- you should get this message

I got that message

Please help. Thank you.
0
 
Rey Obrero (Capricorn1)Commented:
It's written OLE Object  <--- this is Long Binary
0
 
i950Author Commented:
When I double click it, it says "Binary", I have tables when I double click on them I see "long binary data" and those work with my application while "Binary only doesn't work.

Any idea how convert them "completely" to "long binary data"?
0
 
Rey Obrero (Capricorn1)Commented:
well, i guess you my have lost some information when the data was entered to the binary field.
try the conversion of the field to Long Binary in an empty table and fill the field with long binary data.
0
 
i950Author Commented:
I didn't lose anything, but Binary field adds some additional info at the beginning of the file, and when I read it using a programming language and then write it to disk I get unnecessary information at the beginning of the file that is corrupting it :(
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Did we get a resolution to this question?

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
??
0
 
i950Author Commented:
?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 10
  • 9
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now