Storing a byte array in an Access Database

[Jaime]

Hi...

I have to store 1200 bytes in a field of an Access database.Can I use a Memo field? what if a byte is 0? The member variable assotiated with a memo field is of CString class, so I'm not sure if storing the array in a memo field will work.

Any suggestion will be appreciated
Jaime

[PeterK]

You can use CString along with an Access Memo field.

The trick is to change your call to RFX_Text in do your DoFieldExchange method.

For example:
#define MAXCHAR 5000

RFX_Text(pFX, _T("[myField]"), myCString, MAXCHAR);