PG Offline

PG Offline => I need Help ! => Topic started by: John S on July 30, 2009, 09:13:38 AM

Title: Database 90% full
Post by: John S on July 30, 2009, 09:13:38 AM
Now getting the message Database 90% full and I have read the sticky posted above and followed that.
However all that happens is the screen goes grey and then it hangs.
I left it compacting overnight in case it needed more time but this morning still got the grey screen.

Using 3.0.76, anyone got any ideas ?

John S.
Title: Re: Database 90% full
Post by: Wilson Logan on July 30, 2009, 11:32:41 PM
Hi John,

Thats not so good. It sounds like your database is corrupted.

Do you have a copy of Microsoft Access 2000 or later?

If you have, you can open the database (ygroups.mdb) file with Access and use its internal database repair facility.

If not... we have a bit of problem. How big exactly is the database file?


Cheers,

Wilson.
Title: Re: Database 90% full
Post by: John S on July 31, 2009, 01:09:47 AM
That's fixed it.
It was 208,000 and is now 139,000 after repairing in access and compacting.
That doesn't sond large to me ?

John S.
Title: Re: Database 90% full
Post by: Wilson Logan on July 31, 2009, 09:51:28 AM
Hi John,

Thats not big at all.  90% full is somewhere around 1.8GB. The absolute limit is 2GB.

Cheers,

Wilson.