Buffer Size

[cgj]

I have a large Access file with about 4500 image records in binary form. I am trying to import the column into my SQL database and I am encountering a 'Buffer Size' error at the source telling me that the data in the source column is too large for the specified buffer size.

I haven't been able to find anything indicating if I can change this-- any suggestions?

Thanks.

cgj

 

[tlbroadbent]

There is a registry setting called MaxBufferSize that is described in the following documents. I'm not sure that modifying the setting will solve your problem but it may.

Access 97: Adjusting Windows Registry Settings to Improve Performance

http://msdn.microsoft.com/library/o...ndowsregistrysettingstoimproveperformance.htm

Access 2000: Optimizing Your Application

http://msdn.microsoft.com/library/officedev/bapp2000/acbachap07.htm

Terry
------------------------------------
People who don't take risks generally make about two big mistakes a year. People who do take risks generally make about two big mistakes a year. -Peter Drucker