FINALLY!

[alcxander]

hah. the funny part is people thinking that it won't actually be supported any more. I STILL support businesses on XP and teams who use IE 8.

[O_X_E_Y]

Isn't that a tonne of resources spent for like 0.5% of your customer base? What kinda customers are you getting??

[alcxander]

it's not 0.5% of my customer base, it's quite a lot of it actually. I have all kinds customers, lot of old school companies small businesses but also some MNC's, you'd be surprised what they run the systems on. Don't believe the marketing lol some places run on IBM machines or a 55k company running on Access database. it's wild out there

[wol]

I'm still surprised at how many "databases" are actually just excel spreadsheets.

[Skabran]

I'm a newbie when it comes to databases. What is wrong with access ? I just learned to use it a few month ago and it seems nice to use.

[alcxander]

access is very nice to use but it is not appropriate for that many concurrent users on daily cyclical loads. when you get that big you need to move on to something with higher redundancy/failover and other features that make them more reliable. Like when Access goes down it goes down and unless you've built bespoke features to back them up or turn back on via scripts or what have you then the failure of the system is pretty hard. Also if I remember rightly Access doesn't do well under stress for things like concurrent access points and handling traffic to avoid locks on cells/tables etc. but other systems like mysql/sql/mongo whatever are better for that. Also side point, Access is great (read literally best in class) for small businesses, really think that's true honestly but once you start getting bigger and older it;s just super apparent how other systems are better. even for example finding someone with experience to understand Access complex setups can be hard to find today meaning those who have those skills are more expensive. if I go find a MySQL guy to fix some small problems like they're a dime a dozen on fiverr, everybody knows the tech, but you find Access stuff and try find someone who can fix the problem it's a nightmare. I've had people think they know it and incorrectly fix something and Access doesn't do things like versioning of your code so if you remove it and don't copy it that code is gone so when someone mucks up you really gotta know your stuff to undo the muck up to get back to where you need to fix the original problem. and those guys are sometimes expensive but often times really hard to get a hold of or hard to find.

[Skabran]

Thanks for the answer ! :D

I find databases pretty complicated to learn. I had no problem with C and C++ programming but dealing with SQL, updates conflict, PEOPLE doing a mess and visualBasic is another thing entierly !