I ask for urgent assistance in Access

[pashay_zaxo]

Dear brothers and sisters, May Allah reward you for your efforts and put tremendous untold experiences in this great forum

Today I need you as soon as possible if you can help ... The longer you more than that as we enter the heart of the matter ..............

My brothers, my sisters has a database in MS Access a specific name (ahram) since there are several tables and entered into evidence a year or more words about the limits million records exist in the base data, but the question since the day I try to open the file, but to no avail and I can not open, and tried and tried but to no avail, and it shows me Alrsalpaltalip:

Cannot open database 'C: \ documents and settings \ angel \ desktop \ newfolder \ Ahram.mdb'. It may not be a database that your application recognizes, or the file may be corrupt.

I ask that can help to help me open this file

Sincerely,

Azad kurdi

 

[pashay_zaxo]

pleace who can hellp me ...

i want your hellp

 

[Galaxiom]

The size limit on Access databases is 2 GB.
It may be corrupted. If so you would have to revert to a backup.

This is why it is important to split databases, even single user databases. The corrupted front end can be replaced without losing any data.

 

[The_Doc_Man]

In the interest of respect, may I say, peace be unto you.

Now to business. A couple of questions come to mind. First, do you know which version of Access was used to create the file? Second, is that version (or a copy thereof) still available? Third, if you open Access without specifying a file, you can still expose a menu that includes "Compact and Repair" (or the separate "Compact" and "Repair" options on older versions of Access). Once there, you could point to a file to be compacted and repaired. Have you tried that approach?

There is also this to consider. Windows utilities still exist to do a CHKDSK on any disk at any time EXCEPT when you want to check the system disk. For that one disk, you must schedule a CHKDSK run and reboot the system, then wait for the run. Have you tried running CHKDSK on the drive housing that database file?

The event log from a CHKDSK might name a damaged block or range of blocks that impinge on your database file. If that happens, I regret to inform you that you will not open that database ever again without purchasing a commercial database restorer. Even that might not work if the lost blocks are in the very low end of the file (which is where many of the critical structural pointers reside).

I'm with GalaxiomatHome on this one. A backup of this database would be worth its weight in gold.

 

[pashay_zaxo]

The size limit on Access databases is 2 GB.
It may be corrupted. If so you would have to revert to a backup.

This is why it is important to split databases, even single user databases. The corrupted front end can be replaced without losing any data.

Thank you for your assistance


The size limit on Access databases is 2 GB.

Abut the size : my file is less than 2 GB , my file size is limte or less than 600 MB



It may be corrupted
when i open the file i see this in messege



If so you would have to revert to a backup.
My backup file is before one month it mean i entered more than 50 thousand recorder.

this is fatigue for me becuse the data is huge ,every day i enter




This is why it is important to split databases, even single user databases. The corrupted front end can be replaced without losing any data.


Abut this i don't need to split my databse becuse only i am enter no one another .
But abut the replace databse without losing any data i don't how i can do it...
if you can show how i can replace i'll be thank you so mutch



Thank you again and i don't forget your help for me
​

 

[Galaxiom]

This is why it is important to split databases, even single user databases. The corrupted front end can be replaced without losing any data.​

Abut this i don't need to split my databse becuse only i am enter no one another .
But abut the replace databse without losing any data i don't how i can do it...
if you can show how i can replace i'll be thank you so mutch​

I don't think you quite understand this. Databases should be split even if they are single user. The separation of the program (FE) and the data (BE) greatly reduces the risk of corrupting the data.

Unfortuanately splitting is something that can only be done before the problem occurs.

DocMan pretty much covered your options earlier. Have you tried those suggestions?

 

[gemma-the-husky]

it depends what copies or backup of your database you may have, as pointed out.

you may be able to create a new database, and bring the objects (or at least some of them) from the corrupted database into the new one.

it is a little late to find out just how important a good backup plan is - but backing up a database is no different to backing up your photos or anything else. Its vitally improtant

Take a windows copy of the corrupted database before you try anything else - as whatever you do may make the problem worse, not better.