Question

Q: 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.



* 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)
http://www.access-diva.com/tips.html

Did this solve your problem?

Sorry this didn't help.

4 people were helped by this reply


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

Did this solve your problem?

Sorry this didn't help.

6 people were helped by this reply


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

Did this solve your problem?

Sorry this didn't help.


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.

Did this solve your problem?

Sorry this didn't help.

1 person was helped by this reply


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


Did this solve your problem?

Sorry this didn't help.

4 people were helped by this reply


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! 

Did this solve your problem?

Sorry this didn't help.

234 people were helped by this reply


So, the file size goes into the negatives?

Did this solve your problem?

Sorry this didn't help.


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

Did this solve your problem?

Sorry this didn't help.

6 people were helped by this reply


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

Did this solve your problem?

Sorry this didn't help.


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

Did this solve your problem?

Sorry this didn't help.


* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

 
Question Info

Views: 100,271 Last updated: July 19, 2018 Applies to: