This works fine at first, but when it references at least roughly 13,000 cells externally, Excel crashes.Īccess Forms has lots of form events that one can use (though I don't care for how data validation works on bound forms/objects cause it not so user friendly for those that's predominantly mouse users, so I had to build with UNBOUND objects to make the forms more user friendly without sacrificing the strict data validation checks), Excel UserForms has very little Events to work off from.Īccess has a fairly good security model, but I'm still not saying it's real good as it still lacks a few things for what I would like to see from a security stand point of view. In Excel, if using multiple files to compensate for the RAM usage limitation not to mention that calculation also eats away the RAM, try using External Link formula. Therefore to say the least, Excel is very clumsy with data management.Īccess can store X number of records, Excel can only store up to 65536 records on the same sheet without having to use a different set of columns or continue on with other worksheet(s).Īccess has a 2GB memory usage limitation as opposed to Excel having a 80 MB RAM (160 in XP and 03) usage limitation before it crashes.Īccess can query data very easily and NOT run into issues too easily.
Excel now has a warning message box that comes up, but in it's early days, it just sorted regardless. There's a lot, but I'll go into the generals with this.Īccess does not allow for data corruption so easily by a user, such as selecting all but one column, Access will still include all fields for sortings, Excel won't.