Probably written by todays programmers.

I was at a company, program having major problems, All I heard was the DB is all FU'd.

OK, I'm the DBA and look at the code, and the calls into the DB, written in Access (Prob 1) with a SQL Server DB.
For each FIELD on the screen it checks a security db to see if you have rights. REPEAT for each field, individually !!!!!
Ok, and because of the way Access operates each call is really 2 calls to the DB.

There were only 50 to 100 fields on each screen.

Guess what, after you updated it, it went through the same process to see if you had the rights to update the data.

OH it checked the db to see if you had rights to change a field B4 it checked if you changed it, heck it check fields that were not displayed due to the first check.

I got snubed when I complained to the VP that these folks were on my case for showing their quality of workmanship rather than fixing the db to solve the problem.

Not by the VP, he was great, but by the project manager who complained.

__________________
KLK, MCSE

1990 500SL

I was always taught to respect my elders.
I don't have to respect too many people anymore.