Reply to: Can't-believe-we-got-away-with-this thread

[Spacecadet]

The last client I was at I wrote a access db to control the ordering for Central Europe. Thats around 600 stores a few billion pounds a year.

All the buyers have a sheet to "range" products. They select what they are going to buy selling prices click upload and it orders them for it.

Simple. Its how its written not what its made in.

How many forum posts did it take to get it working correctly?

[EternalOptimist]

Which idiot wrote this crap - it is double my usual rate

there was one chap on here a lonnnng time ago who claimed he was getting £60 an hour doing access at a pharma

[BrilloPad]

I frequently see crappy access databases like that, more often than not because the client is having a problem with it (again) and wants me to have a look when I've got a bit of spare time.

Usually my response is "Which idiot wrote this crap?"

Which idiot wrote this crap - it is double my usual rate

[London75]

In their defence, and no I never wrote any app-bases, they did what they needed to do, brought mail merge and report generation to the masses and at a fraction of the cost of the big boy solutions. Also infinitely more flexible.

Wouldn't do it these days but can't help thinking if MS designed a Web version of Access based on a limited implementation of SQL Server and ASP.NET + IIS, they'd make yet more squillions. Probably not worth the investment for them in reality.

Anyone want to go into business with me to make it?

[DiscoStu]

Them and Lotus Notes "databases" / applications.

I used to "code" them years ago

[EternalOptimist]

Yes but I believe that Access nowadays is a different beast to back then (does it use a form of SQL Server?).

In the past with JET you were essential using a single file with some attempt at locking and claiming it was an enterprise level database! This file also contained all the code.

No, its still a stand alone product that can use odbc to link to most things, inluding itself. Locking has always been possible, but do it yourself rather than rely on the engine.

It was never a good idea to mix code with tables, anyone who was any good never did that!

[Peoplesoft bloke]

Yes but I believe that Access nowadays is a different beast to back then (does it use a form of SQL Server?).

In the past with JET you were essential using a single file with some attempt at locking and claiming it was an enterprise level database! This file also contained all the code.

That's nothing, lad! There were plenty of tulip databases around in t'old days - we worked on one called Revelation based on Pick. In PC form it had zillions of files which contained a mixture of data and programs spread throughout - nice. We had some pretty big users too.

[Shimano105]

Yes but I believe that Access nowadays is a different beast to back then (does it use a form of SQL Server?).

In the past with JET you were essential using a single file with some attempt at locking and claiming it was an enterprise level database! This file also contained all the code.

[EternalOptimist]

The last client I was at I wrote a access db to control the ordering for Central Europe. Thats around 600 stores a few billion pounds a year.

All the buyers have a sheet to "range" products. They select what they are going to buy selling prices click upload and it orders them for it.

Simple. Its how its written not what its made in.

spot on my friend.

*sockpuppet rises several notches in estimation*

[Peoplesoft bloke]

That peoplesoft stuff is not that bad. Fortunately you will be fused into a proper technology shortly

Indeed - I am currently "stuck" on old versions - need to find a more cutting edge clientco in the new year.

[Sockpuppet]

The last client I was at I wrote a access db to control the ordering for Central Europe. Thats around 600 stores a few billion pounds a year.

All the buyers have a sheet to "range" products. They select what they are going to buy selling prices click upload and it orders them for it.

Simple. Its how its written not what its made in.

[oracleslave]

Hmm - I don't really want to talk about some of my "skeletons"

That peoplesoft stuff is not that bad. Fortunately you will be fused into a proper technology shortly

[Mich the Tester]

Hmm - I don't really want to talk about some of my "skeletons"

I don't think I'd trust someone who claims his whole career is an unmitigated success story.

[Peoplesoft bloke]

I'll start:
.......

Them were the days - money for old rope!

Hmm - I don't really want to talk about some of my "skeletons"

[expat]

And just like plumbers. Tradesmen everywhere they just love telling you how stupid you were to use the idiot "what did that". These people really irritate me. Why cant they dispense with the humiliation bit identify the problem and then sort it out.

I had an honest plumber once who admitted that he couldn't just slag off the original plumber, "cos it was me dad what did it".