[ShuckyD]

I know (or at least am pretty sure) that Access 97 databases cannot get over the 1gb limit. Unfortunately we have a piece out antiquated software that still uses Access 97 databases so there is always a constant eye out there on certain files. The screenshot below is one of those files. As you can see the filesize and the filesize in parentheses is different, as is with most files that ive seen. Also off to the right it is seen by explorer as 928mb, so a entirely different number than is seen in its properties window.

What i want to know is what is the actual break limit that CRITICAL on Access97 databases? I see 906mb and i see 950mb yet I see 928mb when I check it through My Computer. Which one is the real determining one and also is it 1000mb or is it closer to 1024mb when they begin to "crap out." This has been an on-going thing with this file for the past year or so. It grows to 975mb or more (in explorer) and then we compress it with Access and it get down to about what it is seen at now.. Once i have heard of them compressing it after it broke the 1gb limit. They proceeded to get people out of the software so that they could do a compact on it mid-day.... Thankfully I check it every other day and usually compact it weekly..