I am in the process of moving data from an MS Access 97 DB to SS2000. (Keeping the access frontend) The data was imported using DTS.
There was 1 field in the Access database used to store signatures in the datatype OLE Object (MS Photo Editor 3.0 Photo) I have tried converting to both an Image and a Text datatype but Access can't handle the new field?
The error access gives is "The field is too small to accept the amount of data you attempted to add"
Any ideas?
Thanks in advance
There was 1 field in the Access database used to store signatures in the datatype OLE Object (MS Photo Editor 3.0 Photo) I have tried converting to both an Image and a Text datatype but Access can't handle the new field?
The error access gives is "The field is too small to accept the amount of data you attempted to add"
Any ideas?
Thanks in advance