Cannot open database “. It may not be a database that your application recognizes, or the file may be corrupt.

An Access 2007 database that we recently constructed started giving the following error message when we try to enter attachments, "Cannot open database “.  It may not be a database that your application recognizes, or the file may be corrupt." 

I since became aware that there is a 2 gig limit on table attachments and that apparently is what is causing the error message to appear.  We are right at the 2 gig limit.  Our anticipation was that this database would store approximately 500 gigs of attachments.  However, I can not find anything that tells me an alternate way to  set up the database to store and retrieve document attachments.

Any suggestions would be appreciated.

 

Question Info


Last updated April 4, 2020 Views 140,085 Applies to:

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

Sounds like corruption...  (In your case because of reaching the limit)
http://www.granite.ab.ca/access/corruption/symptoms.htm.

I would make a back-up, make another back-up and then first try importing all but the tables that contain attachments into a new database.  Also, read this article...
http://www.granite.ab.ca/access/corruption/retrievedata.htm.

And after all of that I would finish off with this article...
http://allenbrowne.com/ser-25.html and see if any of those circumstances apply to you.

And when all else fails…
Data Recovery Services (I have never used them but I see them most mentioned when trying to recover data)…
http://www.pksolutions.com/t4.htm

There is nothing aside from upsizing that will allow Access to go beyond its limit.  Which is why most would store only a path to the picture/image and the actual picture/image in a folder in a central location.


--
Gina Whipp
Microsoft MVP (Access)

Please post all replies to the forum where everyone can benefit.
Gina Whipp
Microsoft MVP (Access 2010-2015)
https://www.access-diva.com/tips.html

11 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

If you have reached the limit, Gina is right it may not be recoverable.  But you might consider moving to SQL Server 2008 Express (10Gb limit) and perhaps using SQL Server Migration Assistant (SSMA) can move it over even at the file size you currently have.
Bob Larson, Former Access MVP (2008-2010) http://www.btabdevelopment.com (free Access tools, tutorials, and samples)
-----
Microsoft Access MVP 2008, 2009, 2011
If a post was helpful click the FOUND THIS HELPFUL link

7 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I am experiencing the same but only after creating the database on Office 2010 and trying to open it on a computer with Office 2007.

I thought both would be compatable. No?

 

Randy

1 person was helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I am experiencing the same but only after creating the database on Office 2010 and trying to open it on a computer with Office 2007.

I thought both would be compatable. No?

 

Randy

There is not much backward compatibility for A2010 databases to be used in A2007.
Best to create in Access 2007 and use in Access 2010 - not the other way round.

1 person was helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

An Access 2007 database that we recently constructed started giving the following error message when we try to enter attachments, "Cannot open database “.  It may not be a database that your application recognizes, or the file may be corrupt." 

I since became aware that there is a 2 gig limit on table attachments and that apparently is what is causing the error message to appear.  We are right at the 2 gig limit.  Our anticipation was that this database would store approximately 500 gigs of attachments.  However, I can not find anything that tells me an alternate way to  set up the database to store and retrieve document attachments.

Any suggestions would be appreciated.


Here is a link to a sample database that stores pictures outside the database and stores the links to the pictures in the database.

http://www.rogersaccesslibrary.com/forum/topic298.html


5 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I had the same problem, i found if you run "compact and repair" which can be found in:

Tools > Database Utilities > compact and repair database

it reduced the size by over 100% and it worked completely fine after that! 

300 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

So, the file size goes into the negatives?

5 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Go for click and Tools > Database Utilities > compact and repair database

22 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Mayuri,

First, this question was originally asked 4 years ago. Please check the dates before responding.  Second, if the file is giving an unrecognized format message you can't open it to get to the Tools menu. 

Hope this helps,
Scott<>
Blog: http://scottgem.wordpress.com
Microsoft Access MVP since 2007

3 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi Scott

I am trying to migrate some SQL data (7 GB) into access for a customer and it gives me same error as "Cannot open database “. It may not be a database that your application recognizes, or the file may be corrupt"

Is there a way i can increase the size limit  ? I am sure i cannot go with Tools > Database Utilities > compact and repair database option because data is not loaded in Access from SQL .

Appreciate your response  & help !

Thank you

Annam

4 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.