On Tue, Mar 18, 2008 at 1:17 AM, Helen Borrie <helebor@...> wrote:

> It did. But there is NTFS and NTFS. The NTFS that was implemented for NT4
> has the 4 Gb limit. People upgrade the OS and mistakenly think that it
> upgrades their partition formats. It doesn't. I still have some NT 4 NTFS
> disks around here. And it's surprising also how often we find databases on
> FAT32 partitions. ;-)

Yes, the original NTFS file system had this limitation as well.
Fortunately, I did not have to go through these issues, because I
started using NT 4 with Service Pack 6, which had these issues fixed.
I remember some people complaining that you could not create a system
partition larger than 7.8GB. I don't know if that applied to Service
Pack 6 or not, as I used to create my partitions with GDisk from
Symantec.

The only databases I remember finding in FAT32 partitions are the ones
created with DBase and Clipper. ;-)

> >What causes this to happen?
>
> Human error. :-)

Certainly. We always blame the software, but we are the ones who
created them with bugs in the first place. ;-)

Fidel.

PS: I was reading your mini biography and I must say that I am really
impressed with the many years of experience you have in database
development. I wish I had all that knowledge now. I have always been
an applications programmer, and systems designer. There was always
someone to translate my designs into SQL. But, now that I don't have
someone that experienced I am forced to learn database programming.
And your book has been helping me a lot. It really shows all the
knowledge you acquired during all these years. Thanks!