binary fieldtype

[ganesh vaidyanathan]

Hi,

I am using a database of some previoius version of ms
access and have converted the same for it to be compatible
with my current version i.e. ms access 2000.

After conversion I see that one of the fieldtypes of a
particular table stands as "binary". The client program
stores the value as CByteArray in it.

Neither I am able to change the size (or any properties
for that matter) of that field nor I am able to edit its
value (both from database & from client application)

I believe that there is no such fieldtype called "binary"
that ms access 2000 supports. This is because I dont see
the binary type in the list of fieldtypes that ms access
2000 shows while we click on the fieldtype.

Also that if I have to change the datatype of that field
to someother type which access 2000 supports then I loose
all existing data in it.

Will you please help me in sorting out this problem.

Much appreciated. Thanks.

Ganesh

 

[Tim Ferguson]

Neither I am able to change the size (or any properties
for that matter) of that field nor I am able to edit its
value (both from database & from client application)

Have you tried using GetChunk and AppendChunk?

The later versions of Access and ADO have quietly added a number of SQL-
Server-compliant features without making a lot of fuss about it, for
example check constraints etc.

HTH


Tim F