Working with image data in Access2002 data project

[Mark Neilson]

Following the suggested method of using appendchunk and update to insert
image values in to a recordset:
http://support.microsoft.com/default.aspx?scid=kb;en-us;255632 I receive an
"unspecified error" when I try to do this with a (disconected) recordset
created using currentproject.connection (refer to the subCopyFile routine in
this code.

How can this be achieved using the currentproject.connection property in
Access 2002/2003?

 

[Amy Vargo]

Hi Mark,

My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.

As I understand the issue, you followed the suggested method of using
appendchunk and update to insert
image values in to a recordset:

http://support.microsoft.com/default.aspx?scid=kb;en-us;255632

You receive an "unspecified error" when you try to do this with a
(disconected) recordset
created using currentproject.connection (refer to the subCopyFile routine in
this code.

You need to know how this can be achieved using the
currentproject.connection property in
Access 2002/2003?

I followed the steps in the article and am able to successfully get the
code to work without error. The NothwindCS_2.ade file is successfully
created in C:\My Documents. I did not get an error. I created an Access
2000 file format .adp in Access 2003 connected to a SQL Server 2000
machine.

This of course fails for a disconnected recordset, as the code looks and
writes to the table, but if the recordset is disconnected, of course the
code cannot access it, and will not work.


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Amy Vargo
Microsoft Access Engineer


This posting is provided 'AS IS' with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.