Question access database does not open

[ozdemirozgur]

Hi,

I imported a large data set into my access database and it was fine. However, after closing it i cannot open it again. it gives the following message

Cannot open database. It may not be a database that your application recognizes or file might be corrupted.

the size of the database is more than now 2097 MB and i do not know what to do. It does not open it at all and does not show the compact and repair button.

thanks, ozgur

 

[boblarson]

Access has a maximum of 2Gb storage (INCLUDING system file info). Yours is over 2Gb so it is potentially unrecoverable. Will it let you use a blank Access file and from that one import data from the one that is having the problem?

 

[ozdemirozgur]

Hi Bob,

it does not allow me to import data from it. DO you have any idea to get at least 1 table from the database then it can be less than 2 GB

 

[boblarson]

Do you have a backup copy? Is this on a server and does your IT staff backup the server daily? If so, you will probably have to resort to this and hopefully it won't have too much data you will have to re-enter.

Now, since you have reached that threshold, I would suggest maybe moving to SQL Server Express 2008 R2 as that will hold 10Gb of data. You can still use Access as the frontend.