Thread: Can't change Binary format to Text

I have Microsoft Access 2003 and a table with over 1 million rows and 980 meg file size.
This table as a field created in Binary format and I want to change it in Text format, but it wont let me do it. I get the message ".. cant change the data type - There is not enough disk space or memory". This is not true, I have plenty of disk space and 8 Gb RAM. So how can I sole this problem ?

Binary is not an Access field datatype. Unless you mean Yes/No datatype. What is the datatype of this field?

Google: VBA convert binary to text
http://thydzik.com/vb6vba-functions-...base64-string/
http://www.go4expert.com/forums/showthread.php?t=118

Originally Posted by fdormoy

...and 980 meg file size.

Is that AFTER running COMPACT AND REPAIR?

Anser to first remark : It does show in table design mode that the columns are in Binary. So Binary format do exist and/or are created within Access.

Answer to the second remark : Yes of course I did a Compact and Repair before and it did not help

My comment : I just found a solution whch is to create extra columns which are in text format and with a query update fill in that new column with the same value as the old column which is in binary and then erase the old column. It works !!

I don't see 'Binary' offered as a datatype choice in table design for Access 2007 and 2010.

Glad you found solution.

ou are right for these versions, but I am still working with the old Access 2003 version (as I said in my first post) and may be that old version has this format capability