Error Message

[CQCDave]

I am receiving the following error message "Cannot open database ". It may not be a database your application recognizes, or the file may be corrupt.


I am getting this error when i attempt to attach a pdf file to an attachment field. I am able to create a record in the database, save the record, but unable to attach the file. This error has just started. It is happening on more than 1 table. I am able to open existing records that have attachments and open the attachment already attached to the record.
I have already ran the compact/repair database. Any suggestions on a next step?
Thanks for any insight.
I'm using MS Access 2010.

[Rawb]

How big is your database? If you are trying to add data that brings the size above 2.0 GB, you can get that error.

[CQCDave]

The backend database is 2,096,968KB

[Rawb]

There's your problem. You're right at the limit (you only have about 184KB of space left!). Access databases cannot be larger than 2.0 GB.

One way to decrease the size of your database is to store all of your attachments in the file system while just storing the path to each file in your db. Depending on how complex your database is though, it might take a lot of work.

[CQCDave]

Thanks for your help!!