| Author |
Topic |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
 Posted - 2006-12-13 : 03:46:15
|
| My senior developer told me today that "MS ACCESS is God's gift to Mankind" and "Why use SQL Server when MS ACCESS has so much better interface to the data".Beat that!Peter LarssonHelsingborg, Sweden |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-13 : 03:53:05
|
quote:
MS ACCESS is God's gift to Mankind
WTF!quote:
Why use SQL Server when MS ACCESS has so much better interface to the data.
 ROTFL...I never heard a big joke than that...tell him SQL Server is something more than his damned "better interface".Peter, How do you manage to deal with such people?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-13 : 03:59:09
|
The sad part is that he it NOT joking. He is dead serious. I figured out today that he only uses SQL Server to store data because "of an Executive decision" to use Axapta, aka "not his choice".Almost every of his solutions are built in MS ACCESS, which have linked tables to SQL Server.I don't deal with them. I will give them time until New Years Eve. Then I have to find a new client.Oh! I almost forgot. When getting ready to drive home yesterday, I overheard a conversation between the senior developer and the IT executive. The senior developer told him that I was "incompetent and not up to the challenge".  There you go, folks!Peter LarssonHelsingborg, Sweden |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2006-12-13 : 04:04:33
|
| I had a boss once who said "Frontpage is a professional web development tool, and you should be using it". This was in 1999. I didn't last there long.Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2006-12-13 : 04:05:00
|
| By the way.... quit.Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-13 : 04:15:16
|
| 1999? I can't even remember how FrontPage looked then. Office 95 style, right?Why didn't you last there long? You persisted in using Notepad as the rest of us? Here is another one. I have spent one hour now trying to educate the senior developer about normalization.1NF, 2NF and so on... You get the picture http://www.datamodel.org/NormalizationRules.htmlHowever, all ended with my gasp when senior developer told me that there is no speed difference in JOINS, using 1-1 column JOIN or 7-7 column JOIN. "Given a proper index, the 7-7 column JOIN is as fast a 1-1 column JOIN". THe background is that he is JOINing a 28 million record table with a 250000 record table with 7 columns, 1 datetime - 4 nvarchar - 2 int.Peter LarssonHelsingborg, Sweden |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-12-13 : 05:17:18
|
| "The senior developer told him that I was ..."You should have asked us Peso ... we would have told you exactly how you are ... |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-13 : 05:23:05
|
Pain in the ass SuperPoster?  Peter LarssonHelsingborg, Sweden |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-12-13 : 05:26:14
|
| but you know what takes the cake?in a year or so we'll be reading about a "stupid and incompetent" consultant on www.thedailywtf.comand we'll recongnize the peter in that story. the story will be submitted by the senior developer. that's the way world turns...Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-13 : 05:33:37
|
quote:
that's the way world turns...
No doubt about that.Peter LarssonHelsingborg, Sweden |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-12-13 : 07:00:08
|
| Looking forward to your 5-minutes-of-fame then mate?! |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-12-13 : 11:01:30
|
| Yes. Access is better because it has both Front end and back end Did you ever tell him to write queries in Access that you wrote in SQL Server?MadhivananFailing to plan is Planning to fail |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2006-12-13 : 15:24:43
|
| >"MS ACCESS is God's gift to Mankind"ALL professional products are gifts to the mankind.What's wrong with his opinion...======================Let me hug & kiss you... |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-13 : 15:29:11
|
| 1) Microsoft licensing schema is not a gift.2) He uses MS ACCESS as a front-end for 400+ user database. 400 users has this application running against a sql server. Why not write some ASP pages that does the same thing? They only report numbers and run som report...There are no foreign keys, no single-column primary keys, always multiple-column primary keys.He does not use PASSTHROUGH, so ACCESS has to do all the calculation too...Peter LarssonHelsingborg, Sweden |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2006-12-13 : 16:04:28
|
quote:
Originally posted by Peso
1) Microsoft licensing schema is not a gift.2) He uses MS ACCESS as a front-end for 400+ user database. 400 users has this application running against a sql server. Why not write some ASP pages that does the same thing? They only report numbers and run som report...There are no foreign keys, no single-column primary keys, always multiple-column primary keys.He does not use PASSTHROUGH, so ACCESS has to do all the calculation too...Peter LarssonHelsingborg, Sweden
Couple of things ...1) Access is very good at running reports using linked tables, much better than using ASP. The reporting tool is quite flexible and powerful, with subreports, conditional formatting, VBA support, events, custom criteria forms with drop-downs and validation, etc .... If all it does is run reports, why should it be a web application?2) Access is quite good at generating and passing SQL to the server using linked tables; you don't always have to use pass-through queries to have this done. If you create an Access query that joins 10 tables, all linked, with some criteria and grouping on them, as long as you don't use any VBA functions or Access-only features, the entire thing is sent to the server and executed there. If you know what you are doing, it is very, very efficient.Don't knock Access; it is a very valuable and flexible tool, and always, always remember it is not an alternative to SQL Server -- they are two completely different beasts. As I say often, if I need to convert lots of data from one system to the next, Access is an amazing tool for the job -- you get reports, VBA, local storage, linked tables, data entry forms, and everything all rolled into one.As always, it's not the tools, it's how you use them.- Jeff |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-13 : 16:17:32
|
| The thing is, if the senior developer had any decision making power, he would throw SQL Server out, and have Axapta and all other applications run against MS ACCESS. 400+ simultaneous users... That's the situation and he never stop letting other people (especially me, since I was hired to assist him) know his position.According to him Axapta is the world's worst application and the one he built in early 80's was so much better.Well, no point in rambling.Peter LarssonHelsingborg, Sweden |
|
|
|
PSamsig
Constraint Violating Yak Guru
384 Posts |
Posted - 2006-12-13 : 17:37:03
|
quote:
Originally posted by Peso
7 columns, 1 datetime - 4 nvarchar - 2 int.
carefulll ... or you will yet again let the natural key monster out again ...-- If you give someone a program, you will frustrate them for a day; if you teach them how to program, you will frustrate them for a lifetime. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-13 : 17:46:57
|
| Shall we start it? Peter, are you then on the surrogate key side of the debate?Tara Kizer |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-13 : 18:06:00
|
| If I have to choose, I would mostly go for surrogate key.But I have found scenarios where natural keys come in handy too.Since I am a VB 6.0 developer I mostly choose the surrogate key, because the key can be added to lists, combos, grids and so on...Peter LarssonHelsingborg, Sweden |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-13 : 18:10:41
|
| It was a rhetorical question. We certainly don't want to start that debate again!Tara Kizer |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-12-13 : 21:56:17
|
quote:
Originally posted by Peso
My senior developer told me today that "MS ACCESS is God's gift to Mankind" and "Why use SQL Server when MS ACCESS has so much better interface to the data".
Oh my, some people make it too easy.In case you get bored and you have access to his Access, run this little puppy in a VB module:Public Sub duh()Dim p As DAO.PropertySet p = CurrentDb.CreateProperty("AllowBypassKey", dbBoolean)p.Value = FalseCurrentDb.Properties.Append pEnd SubDon't save it, just run it once. You'll probably have to add a reference to a DAO library first. Basically this disables the Shift-key bypass, so the database will always open using the startup form and/or AutoExec macro.Naturally you'll want to change that form/macro to something...unexpected. And if you disable the standard menus and toolbars, he'll have a helluva time fixing it. |
|
|
|
Next Page
|
High-sounding Empty Phrases or Empty Rhetoric