Run Time Error 3049 - "Cannot open database ''.

[CuriousGeorge]

Ive started to fill my database with data and after reading data into my table i got following error:

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

Tried to add more files but same error.

My table contains at the moment 11,3 million rows (records) and (14 columns). Has it reached its limit? It is only double values that is stored in the table.

If not limit, how do i get around the problem?

Thanks

 

[DCrake]

What is the physical size of your mdb/accdb? have you run a compact and repair yet. If not suggest you do, and if the file is on a server copy it locally first.

 

[CuriousGeorge]

viewing it in explorer it is 2,095GB.

Dunno what compact repair is, have to google it. But the database still works, the database file is not corrupt.

I guess the database has reached its limit in that case if it is above 2GB?

Thanks

 

[DCrake]

This might not be the case. It may contain alot of bloated space compact and repair will remove the bloating. What version of Access are you using?

 

[CuriousGeorge]

it is version 2007

 

[DCrake]

Click on the Big Access button (top left of screen) Then Manage > Compact and repair. Save it under a different name, if you do not Access will most likely crash as it needs to keep 2 times size in memory/cache.

 

[CuriousGeorge]

Thanks David, appreciate it

 

[DCrake]

Has it reduced in size?

 

[CuriousGeorge]

yeah significantly, reduced by a factor of 4

Cheers mate

 

[DCrake]

Just need to remember to do this regularly in future

 

[boblarson]

And if you regularly hit the 2Gb limit you might consider moving to SQL Server 2008 R2 Express since it can handle 10Gb.