The DataBase is corrupted and must be repared....

[Rodolfo Fontes]

Hi group,

The following message appears frequently on the database, and I don't know
why: "The database is corrupted and must be repared..."
To solve this, i have 2 options.
1 - Sometimes just ask to others users to close their databases
(access), then, without reparing it come back to work, without any problems.
2 - Sometimes, i ask users to close their systems too, but it still
cannot be open, so i must use the option "Compress and Repair Database"
I've tried to open a blank database then import everything to this one...
Also tried to make new tables, relashionship, import data... nothing worked.
My version of Access is 2000, since i'm on another citie, i use "Remote
Desktop Connection" to connect to the Windows Server (2003) then open the
database, that is on the SAMBA server.
The reason for using samba was that when using access database on NFTS, or
another windows partition, the system crashes, and with SAMBA it works
(worked until then) fine.

Does anyone have some idea on what's going on?

Thanks for all,
Rodolfo Fontes

 

[John Vinson]

The following message appears frequently on the database, and I don't know
why: "The database is corrupted and must be repared..."

If you have not already done so, check out the extensive prevention
and remediation suggestions at

http://www.granite.ab.ca/access/corruptmdbs.htm


John W. Vinson[MVP]

 

[Rodolfo Fontes]

I didn't see it before... look great...

Thanks,
Rodolfo Fontes