MS Access is NOT and Enterprise Solution
-
I have found that the second a client finds out what can (potentially) be done with MS Access (or any other cheap solution) they then try to see how much work they can get done with this database software program. This is a bad thing in so many respects and on so many levels. I proposed C# with SQL Server - minimum. They wanted and "they payed" my company to see what I can get done with Access 2007. I told them their dreams will turn into nightmares in less than one month's time. They did not believe me. My advice and concerns have turned into reality. Microsoft Access is not meant to be a multi-user data entry system...it is not dependable and it crashes all the time and is constantly prone to corruption. Even Microsoft says that Access is not meant for this kind of work. I had no choice in the matter. I don't work for myself. I am not independently wealthy. I "need" this job right now; I have a family and bills to pay. Yet I am forced into working in a constant state of futility. Our client is a big-house and pays very well. Why couldn't they pay for the right solution to the problem the first time instead of taking the "usual" cheap man's way out is beyond me. I don't even know why my company allowed this contract to take off in the first place (a side from the money). I am emotionally spent. I need a vacation. They want me and another dumb-ass programmer to do a "complete" re-write. Thanks for reading.
-
I have found that the second a client finds out what can (potentially) be done with MS Access (or any other cheap solution) they then try to see how much work they can get done with this database software program. This is a bad thing in so many respects and on so many levels. I proposed C# with SQL Server - minimum. They wanted and "they payed" my company to see what I can get done with Access 2007. I told them their dreams will turn into nightmares in less than one month's time. They did not believe me. My advice and concerns have turned into reality. Microsoft Access is not meant to be a multi-user data entry system...it is not dependable and it crashes all the time and is constantly prone to corruption. Even Microsoft says that Access is not meant for this kind of work. I had no choice in the matter. I don't work for myself. I am not independently wealthy. I "need" this job right now; I have a family and bills to pay. Yet I am forced into working in a constant state of futility. Our client is a big-house and pays very well. Why couldn't they pay for the right solution to the problem the first time instead of taking the "usual" cheap man's way out is beyond me. I don't even know why my company allowed this contract to take off in the first place (a side from the money). I am emotionally spent. I need a vacation. They want me and another dumb-ass programmer to do a "complete" re-write. Thanks for reading.
Slacker007 wrote:
don't even know why my company allowed this contract to take off
Slacker007 wrote:
hey want me and another dumb-ass programmer to do a "complete" re-write.
There - you answered your own question
___________________________________________ .\\axxx (That's an 'M')
-
I have found that the second a client finds out what can (potentially) be done with MS Access (or any other cheap solution) they then try to see how much work they can get done with this database software program. This is a bad thing in so many respects and on so many levels. I proposed C# with SQL Server - minimum. They wanted and "they payed" my company to see what I can get done with Access 2007. I told them their dreams will turn into nightmares in less than one month's time. They did not believe me. My advice and concerns have turned into reality. Microsoft Access is not meant to be a multi-user data entry system...it is not dependable and it crashes all the time and is constantly prone to corruption. Even Microsoft says that Access is not meant for this kind of work. I had no choice in the matter. I don't work for myself. I am not independently wealthy. I "need" this job right now; I have a family and bills to pay. Yet I am forced into working in a constant state of futility. Our client is a big-house and pays very well. Why couldn't they pay for the right solution to the problem the first time instead of taking the "usual" cheap man's way out is beyond me. I don't even know why my company allowed this contract to take off in the first place (a side from the money). I am emotionally spent. I need a vacation. They want me and another dumb-ass programmer to do a "complete" re-write. Thanks for reading.
Slacker007 wrote:
They want me and another dumb-ass programmer to do a "complete" re-write.
Completely rewrite it in C#/SQL. Maybe they don't want to spend money on a server box for SQL (I know, that's no excuse, but still...)
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997 -
I have found that the second a client finds out what can (potentially) be done with MS Access (or any other cheap solution) they then try to see how much work they can get done with this database software program. This is a bad thing in so many respects and on so many levels. I proposed C# with SQL Server - minimum. They wanted and "they payed" my company to see what I can get done with Access 2007. I told them their dreams will turn into nightmares in less than one month's time. They did not believe me. My advice and concerns have turned into reality. Microsoft Access is not meant to be a multi-user data entry system...it is not dependable and it crashes all the time and is constantly prone to corruption. Even Microsoft says that Access is not meant for this kind of work. I had no choice in the matter. I don't work for myself. I am not independently wealthy. I "need" this job right now; I have a family and bills to pay. Yet I am forced into working in a constant state of futility. Our client is a big-house and pays very well. Why couldn't they pay for the right solution to the problem the first time instead of taking the "usual" cheap man's way out is beyond me. I don't even know why my company allowed this contract to take off in the first place (a side from the money). I am emotionally spent. I need a vacation. They want me and another dumb-ass programmer to do a "complete" re-write. Thanks for reading.
What does it matter that what you do is stupid and irrelevant and will become obsolete in a month - it puts food on the table, right?
1f y0u c4n r34d 7h15 y0u r3411y n33d 70 g37 14!d Gotta run; I've got people to do and things to see... Don't tell my folks I'm a computer programmer - They think I'm a piano player in a cat house... Da mihi sis crustum Etruscum cum omnibus in eo!
-
I have found that the second a client finds out what can (potentially) be done with MS Access (or any other cheap solution) they then try to see how much work they can get done with this database software program. This is a bad thing in so many respects and on so many levels. I proposed C# with SQL Server - minimum. They wanted and "they payed" my company to see what I can get done with Access 2007. I told them their dreams will turn into nightmares in less than one month's time. They did not believe me. My advice and concerns have turned into reality. Microsoft Access is not meant to be a multi-user data entry system...it is not dependable and it crashes all the time and is constantly prone to corruption. Even Microsoft says that Access is not meant for this kind of work. I had no choice in the matter. I don't work for myself. I am not independently wealthy. I "need" this job right now; I have a family and bills to pay. Yet I am forced into working in a constant state of futility. Our client is a big-house and pays very well. Why couldn't they pay for the right solution to the problem the first time instead of taking the "usual" cheap man's way out is beyond me. I don't even know why my company allowed this contract to take off in the first place (a side from the money). I am emotionally spent. I need a vacation. They want me and another dumb-ass programmer to do a "complete" re-write. Thanks for reading.
Slacker007 wrote:
I need a vacation
Even prostitutes get tired of lying around... ;P Take a break, then rewrite it the way it should have been done the first time. If money's the issue, target SQL Server Express edition and let the customer decide when it's time to upgrade. The benefits of the better platform should be immediately obvious to them. I know that SQL Server is a hard sell, as ridiculously expensive as it is, but experience should make the choice a lot easier for the client.
Will Rogers never met me.
-
Slacker007 wrote:
I need a vacation
Even prostitutes get tired of lying around... ;P Take a break, then rewrite it the way it should have been done the first time. If money's the issue, target SQL Server Express edition and let the customer decide when it's time to upgrade. The benefits of the better platform should be immediately obvious to them. I know that SQL Server is a hard sell, as ridiculously expensive as it is, but experience should make the choice a lot easier for the client.
Will Rogers never met me.
Roger Wright wrote:
Even prostitutes get tired of lying around...
True, once in a while they need a few days on their feet... (or so I've heard!) ;P
1f y0u c4n r34d 7h15 y0u r3411y n33d 70 g37 14!d Gotta run; I've got people to do and things to see... Don't tell my folks I'm a computer programmer - They think I'm a piano player in a cat house... Da mihi sis crustum Etruscum cum omnibus in eo!
-
What does it matter that what you do is stupid and irrelevant and will become obsolete in a month - it puts food on the table, right?
1f y0u c4n r34d 7h15 y0u r3411y n33d 70 g37 14!d Gotta run; I've got people to do and things to see... Don't tell my folks I'm a computer programmer - They think I'm a piano player in a cat house... Da mihi sis crustum Etruscum cum omnibus in eo!
Johnny J. wrote:
What does it matter that what you do is stupid and irrelevant and will become obsolete in a month - it puts food on the table, right?
It matters to me. It matters that I do a job the "right" way regardless of how obsolete it will become.
-
Johnny J. wrote:
What does it matter that what you do is stupid and irrelevant and will become obsolete in a month - it puts food on the table, right?
It matters to me. It matters that I do a job the "right" way regardless of how obsolete it will become.
If you feel that way, then you shouldn't work for others. You should be in business for yourself. As long as you work for others, they will always make you do stuff that you feel is stupid. What I'm trying to do is give you a piece of advice: Don't take things so seriously - otherwise you will NEVER be content with your lot in life!
1f y0u c4n r34d 7h15 y0u r3411y n33d 70 g37 14!d Gotta run; I've got people to do and things to see... Don't tell my folks I'm a computer programmer - They think I'm a piano player in a cat house... Da mihi sis crustum Etruscum cum omnibus in eo!
-
Slacker007 wrote:
I need a vacation
Even prostitutes get tired of lying around... ;P Take a break, then rewrite it the way it should have been done the first time. If money's the issue, target SQL Server Express edition and let the customer decide when it's time to upgrade. The benefits of the better platform should be immediately obvious to them. I know that SQL Server is a hard sell, as ridiculously expensive as it is, but experience should make the choice a lot easier for the client.
Will Rogers never met me.
There are other options, such as MySQL, that provide enterprise databases that don't break the bank. Bit of a learning curve if its new to you, but worth considering.
-
Slacker007 wrote:
They want me and another dumb-ass programmer to do a "complete" re-write.
Completely rewrite it in C#/SQL. Maybe they don't want to spend money on a server box for SQL (I know, that's no excuse, but still...)
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997John Simmons / outlaw programmer wrote:
Completely rewrite it in C#/SQL.
It will be. I started working on it last Friday.
John Simmons / outlaw programmer wrote:
Maybe they don't want to spend money on a server box for SQL
At first this was one of the reasons. However, they realize now that their is no other way.
-
If you feel that way, then you shouldn't work for others. You should be in business for yourself. As long as you work for others, they will always make you do stuff that you feel is stupid. What I'm trying to do is give you a piece of advice: Don't take things so seriously - otherwise you will NEVER be content with your lot in life!
1f y0u c4n r34d 7h15 y0u r3411y n33d 70 g37 14!d Gotta run; I've got people to do and things to see... Don't tell my folks I'm a computer programmer - They think I'm a piano player in a cat house... Da mihi sis crustum Etruscum cum omnibus in eo!
I hear what you are saying. I know I need to learn to laugh it off - my wife says the same thing.
-
Slacker007 wrote:
I need a vacation
Even prostitutes get tired of lying around... ;P Take a break, then rewrite it the way it should have been done the first time. If money's the issue, target SQL Server Express edition and let the customer decide when it's time to upgrade. The benefits of the better platform should be immediately obvious to them. I know that SQL Server is a hard sell, as ridiculously expensive as it is, but experience should make the choice a lot easier for the client.
Will Rogers never met me.
Roger Wright wrote:
I know that SQL Server is a hard sell, as ridiculously expensive as it is, but experience should make the choice a lot easier for the client.
... and more than a few extra days of development time spent fighting with the WTF known as access isn't? :doh:
3x12=36 2x12=24 1x12=12 0x12=18
-
I hear what you are saying. I know I need to learn to laugh it off - my wife says the same thing.
Good boy! Listen to the misses - she's always right! :thumbsup:
1f y0u c4n r34d 7h15 y0u r3411y n33d 70 g37 14!d Gotta run; I've got people to do and things to see... Don't tell my folks I'm a computer programmer - They think I'm a piano player in a cat house... Da mihi sis crustum Etruscum cum omnibus in eo!
-
What does it matter that what you do is stupid and irrelevant and will become obsolete in a month - it puts food on the table, right?
1f y0u c4n r34d 7h15 y0u r3411y n33d 70 g37 14!d Gotta run; I've got people to do and things to see... Don't tell my folks I'm a computer programmer - They think I'm a piano player in a cat house... Da mihi sis crustum Etruscum cum omnibus in eo!
Johnny J. wrote:
What does it matter that what you do is stupid and irrelevant
If you have an skerrick of pride and professionalism then it matters a great deal. I have the greatest sympathy for a developer who's recommendations are watered down to the point where they are ineffective and it hurts even more when the client is a major organisation.
Never underestimate the power of human stupidity RAH
-
I hear what you are saying. I know I need to learn to laugh it off - my wife says the same thing.
look at it from the 'big picture' perspective. The company wanted a solution. Your company wanted to provide one. You wanted to provide a good, technical solution. What is the outcome? All three parties wishes are granted! It's win-win-win sure you developed a prototype in Access, but I bet you learned a lot doing that that will be useful in the rewrite? Meantime your company has been paid, you've been paid and the company you're developing the software for has just paid a little more than they may have
___________________________________________ .\\axxx (That's an 'M')
-
There are other options, such as MySQL, that provide enterprise databases that don't break the bank. Bit of a learning curve if its new to you, but worth considering.
OK, now I'm gonna have to stick my chin out: MySQL is a toy - it's perhaps ok for internal applications, but it shouldn't be used for applications that are used outside the office by real users. I was working for a company a couple of years ago that had used MySQL as backend for their webshop. And in the end we were stuck to using a several years old version of MySQL, because every time we tried updating to a newer version, it would break the application, needless to say, it aggrevated our customers and we lost business every time.
1f y0u c4n r34d 7h15 y0u r3411y n33d 70 g37 14!d Gotta run; I've got people to do and things to see... Don't tell my folks I'm a computer programmer - They think I'm a piano player in a cat house... Da mihi sis crustum Etruscum cum omnibus in eo!
modified on Tuesday, February 8, 2011 9:01 AM
-
OK, now I'm gonna have to stick my chin out: MySQL is a toy - it's perhaps ok for internal applications, but it shouldn't be used for applications that are used outside the office by real users. I was working for a company a couple of years ago that had used MySQL as backend for their webshop. And in the end we were stuck to using a several years old version of MySQL, because every time we tried updating to a newer version, it would break the application, needless to say, it aggrevated our customers and we lost business every time.
1f y0u c4n r34d 7h15 y0u r3411y n33d 70 g37 14!d Gotta run; I've got people to do and things to see... Don't tell my folks I'm a computer programmer - They think I'm a piano player in a cat house... Da mihi sis crustum Etruscum cum omnibus in eo!
modified on Tuesday, February 8, 2011 9:01 AM
Haven't used it meself - but I know MySQL is in use out there inthe real world in million-hits=per-day sites Maybe you had a bad experience - and why were you updating to the newer version if it broke the application anyway - unbless there was already something wrong?
___________________________________________ .\\axxx (That's an 'M')
-
I have found that the second a client finds out what can (potentially) be done with MS Access (or any other cheap solution) they then try to see how much work they can get done with this database software program. This is a bad thing in so many respects and on so many levels. I proposed C# with SQL Server - minimum. They wanted and "they payed" my company to see what I can get done with Access 2007. I told them their dreams will turn into nightmares in less than one month's time. They did not believe me. My advice and concerns have turned into reality. Microsoft Access is not meant to be a multi-user data entry system...it is not dependable and it crashes all the time and is constantly prone to corruption. Even Microsoft says that Access is not meant for this kind of work. I had no choice in the matter. I don't work for myself. I am not independently wealthy. I "need" this job right now; I have a family and bills to pay. Yet I am forced into working in a constant state of futility. Our client is a big-house and pays very well. Why couldn't they pay for the right solution to the problem the first time instead of taking the "usual" cheap man's way out is beyond me. I don't even know why my company allowed this contract to take off in the first place (a side from the money). I am emotionally spent. I need a vacation. They want me and another dumb-ass programmer to do a "complete" re-write. Thanks for reading.
Just see it as part of educating the children. You have to let your children make their own mistakes, that's how they learn. I see this happening all the time, and it doesn't freak me out. All you can do is give them the information you have, and let them make the choice. Often in half a year, or a year time they will see the light. Programming is a matter of years and years anyway, so who cares if a small Access application went to waste (see it as a prototype).
Wout
-
OK, now I'm gonna have to stick my chin out: MySQL is a toy - it's perhaps ok for internal applications, but it shouldn't be used for applications that are used outside the office by real users. I was working for a company a couple of years ago that had used MySQL as backend for their webshop. And in the end we were stuck to using a several years old version of MySQL, because every time we tried updating to a newer version, it would break the application, needless to say, it aggrevated our customers and we lost business every time.
1f y0u c4n r34d 7h15 y0u r3411y n33d 70 g37 14!d Gotta run; I've got people to do and things to see... Don't tell my folks I'm a computer programmer - They think I'm a piano player in a cat house... Da mihi sis crustum Etruscum cum omnibus in eo!
modified on Tuesday, February 8, 2011 9:01 AM
I never did much with MySQL, besides using it for the web forum software that uses it. All the software that I write myself is using SQL Server Express, and I'm very satisfied with it. The SQL Server Management Studio (express version) is pretty good too: auto completion, squigglies, script generation, couldn't wish for much more I have to say.
Wout
-
I never did much with MySQL, besides using it for the web forum software that uses it. All the software that I write myself is using SQL Server Express, and I'm very satisfied with it. The SQL Server Management Studio (express version) is pretty good too: auto completion, squigglies, script generation, couldn't wish for much more I have to say.
Wout
That's one I can buy! And also if you're looking for a single file solution as MS Access, there's SQL Server Compact Edition. But it's not quite as versatile as the Express version.
1f y0u c4n r34d 7h15 y0u r3411y n33d 70 g37 14!d Gotta run; I've got people to do and things to see... Don't tell my folks I'm a computer programmer - They think I'm a piano player in a cat house... Da mihi sis crustum Etruscum cum omnibus in eo!