By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,561 Members | 3,127 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,561 IT Pros & Developers. It's quick & easy.

Export one record from database including a picture as an OLE object

P: 10

I have a Access 200 format database that contains contact details and a picture for each record. The contact details are held in one table and the images are held in another as OLE Objects. This database is used to produce passes.

I want to export one record from the dartabase including the picture into a format that can be easily tansferred by email.

I've created a query based on the two tables that will retreive all the details based on id. used the query to create a report and then exported the report to xml. However when I try to import this xml file into another database it fails with the errors

Error Message
Field truncation
Microsoft JET Database Engine: The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
Microsoft JET Database Engine: Update or CancelUpdate without AddNew or Edit.
Microsoft JET Database Engine: Update or CancelUpdate without AddNew or Edit.

I've also tried to just export the picture seperately in xml but this also produces the above errors.

What would be the best way to go about doing this?
I can export the setails seperately as a csv file but I'm struggling to export the picture, even when I preview the report a box appears for the picture but I cannot see the photo.
The image table is made up of the following fields

ID number
length number
picture OLE Object
type number

Any help is appreciated.

Sep 20 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,072

Post your reply

Sign in to post your reply or Sign up for a free account.