Adding attachments causes database to crash

I am attaching .jpg images and other files to botanical records on a form in
Access 2007 using the attachments control. The attachments conform in size
and other parameters to those allowed by Access. Every so often a dialog box
appears on closing the attachments pop-up which says 'Cannot open database
".It may not be a
database that your application recognizes, or the file may be corrupt'
When I click on help it lists this as Error 3049. Repairing the database
doesn't help.
Eventually the database crashes and I have to restore from a backup which is
frustrating as I am having to re-enter lots of data
A previous suggestion was to decompile the module but I don't understand
what is implied by this
The DB is on a private computer and I am both user and administrator

Any ideas please?

docmike wrote:

>I am attaching .jpg images and other files to botanical records on a form in
>Access 2007 using the attachments control. The attachments conform in size
>and other parameters to those allowed by Access.

Do you have the Office 2007 SP1 installed? How large is the data
MDB in which you are putting the attachments? Is it anywhere close to
2 Gb? When was the last time you compacted it?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/