Adding attachments causes database to crash

[docmike]

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?

 

[Tony Toews [MVP]]

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/

 

[docmike]

Thanks Tony

I have Office 2007 Enterprise edition which I think has SP1 already in it -
not sure. Yes my DB is near 2GB and I have realised that is the problem, now
solved by attaching smaller jpegs. I thought the attachments in Access 2007
didn't swell the DB size as embedding OLE objects in previous versions did,
and 2GB seems a very small overall limit for a DB. I don't really understand
about the larger DBs like SQL server. Can you import from a mdb file? Do you
have to know code?

Mike

 

[Tony Toews [MVP]]

I have Office 2007 Enterprise edition which I think has SP1 already in it -
not sure. Yes my DB is near 2GB and I have realised that is the problem, now
solved by attaching smaller jpegs. I thought the attachments in Access 2007
didn't swell the DB size as embedding OLE objects in previous versions did,

As far as I know yes A2007 does a much better job of graphic
attachments. So I'm a bit puzzled here.

and 2GB seems a very small overall limit for a DB.

In terms of records that's a lot of data. But as soon as you start
adding a lot of attachments then yes it does get too small.

I don't really understand
about the larger DBs like SQL server. Can you import from a mdb file? Do you
have to know code?

No, you don't necessarily need to know code. However I do believe
that free version of SQL Server 2008 has a 4 Gb database size limit.
Then you need to purchase SQL Server 2008 of some version and CALs
(Client Access Licenses.)

In general we suggest to folks that they handle attachments by leaving
them as files on the server hard drive. This simplifies many things
including not having to copy them out to the hard drive if the user
needs to view the file.

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/