Temporarily remove referential integrity checks through VBA?

[Andrew R]

Hi

I'm creating a series of forms, each with with around 15-20 text boxes.
The text boxes will show data from tables, but are unbound to make them
more flexible.

I want the form to be used for both adding new data and modifying
existing data. I have created a save button on the form.

When the user clicks the save button, the code checks to see if there
is a value in the ID text box. If not, it assumes that the record is
new and uses an "Insert into..." SQL statement as the ADODB command
text. This works fine.

However, if there is already an ID value present, the logic is that the
record already exists, and therefore we are doing an update. Creating a
SQL statement along the lines of "UPDATE tblCustomers SET strFirstName
= " & txtFirstName.text & ", strLastName=" & txtLastName.text
...... and so on seems to be a lot of coding to update perhaps 14 fields
which haven't changed in addition to the one that may have.

Therefore, my question is this: Is there an easy way to detect which
field has been changed (without writing code behind each text box,
given that Access doesn't allow control arrays... It probably seems
like I'm being lazy, but with probably 8 or so forms, each with 15-20
text boxes, that would be a lot of work!)

Assuming not, my other thought was that it would be much simpler to
simply execute 2 commands -
"Delete from tblCustomers where ID=" & txtID.text
and then run the insert statement as before. However, this will of
course be prevented by the referential integrity constraints on the
table, thus my question - is there a way through the code to turn off
checks, run the delete and insert statements, then turn them on again?

Apologies for being long-winded! Any help gratefully received!

Regards
Andrew Richards

[Lyle Fairfield]

Lyle Fairfield wrote:

db*******@hotmail.com wrote:

I am much better at Access AND Sql than anyone i've
ever seen on this newsgroup.

We're all grateful that you have shared your expertise here in CDMA.
But some of us may have missed one or two of your better contributions.
Would you list the links to a few, say ten, of your creative and
original posts so that we can reference them as a small library of
excellence?

In addition, this may help us to remember to maintain the appropriate
level of deferential integrity in our discussions with you.

Better yet why not create a compendium of these wonderful ideas in an
SQL-Server Table with code and descriptions in Text fields? You could
then create and make freely available an ADP which would allow us all
to access your wonderful ideas. I'm sure, that you, as El Supremo
ADP/SQL can craft your application in such a way that there will be no
security breaches or concerns.
In that way you can not only show, but also demonstrate the magnificent
qualities of the ADP. What an opportunity!

[dbahooker]

Terry

fuck yourself

Terry Kreft wrote:

Ha, ha, ha, it's just marvellous how you have not the slightest piece of
self-respect.

Please continue to show us how wonderful you are<g>; I've quite given up
reading Dilbert as your contributions are so much more originally funny.

You might not know much about programming (except in your world of course)
but you certainly know how to amuse!

I've only seen one piece of code from you and it was so laughably wrong but
far too subtle I thought, most people probably thought you meant it to be
like that.
--

Terry Kreft
<db*******@hotmail.com> wrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...

Terry;

screw yourself; I am much better at Access AND Sql than anyone i've
ever seen on this newsgroup.

And most importantly; I dont just blindly use the first tool the comes
across my desk.

I use the best tool for whatever I am doing.

Most of your idiots are unnecessarily biased agasint Access Data
Projects.
I find that laughable.
-Aaron
Terry Kreft wrote:

I love the way that you have no compunction about showing how ignorant you are of both transact SQL and Access SQL and the way that you're not afraid of displaying your stupidity in public is really marvelous.
--

Terry Kreft
<aa*********@gmail.com> wrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...
> good stuff
>
>
> IF EXISTS (SELECT TOP 1 'X' FROM newsgroup WHERE tool_of_choice =
> 'MDB')
> BEGIN
> RAISERROR ('oh wait a second mdb can't handle real tsql
> statements; it is for babies', 16, 127, 'horsecrap')
> END
>
>
>
>
>
>
> Terry Kreft wrote:
> > IF EXISTS (SELECT * FROM newsgroup WHERE user_name = 'aaron')
> > BEGIN
> > DELETE FROM newsgroup WHERE user_name = 'aaron'
> > RAISERROR ('Troll alert - %d talking garbage', 16, 127, 'aaron')
> > END
> >
> >
> > --
> >
> > Terry Kreft
> >
> >
> > <aa*********@gmail.com> wrote in message
> > news:11*********************@u72g2000cwu.googlegro ups.com...
> > > fucking retards
> > >
> > > SQL Server is more powerful
> > > anyone that uses MDB in the year 2006?
> > >
> > > you should spit on them.
> > > out of the blue; just walk up to them and spit.
> > >
> > > you can have constraints-- you can have triggers-- you can have custom > > > dataTypes
> > >
> > >
> > >
> > >
> > > rkc wrote:
> > > > Jamie Collins wrote:
> > > > > rkc wrote:
> > > > >
> > > > >>What does SQL have to do with referential integrity?
> > > > >
> > > > >
> > > > > http://en.wikipedia.org/wiki/SQL
> > > > >
> > > > > See the 'Concepts' section.
> > > >
> > > > I didn't see any mention of SQL in the Referential Integrity
> > > > entry under that topic.
> > >
>

[dbahooker]

for the record

sql server security is a LOT better than your silly MDB bullshit.

can you kids even prevent me from updating a single table?

I'm sorry that you idiots try to TALK_SHIT about people just because
they're willing to think OUTSIDE THE BOX.

Just because I dont have to compact and repair my database every 3
days?? that makes me less of a man?

Because I dont spend half my time re-syncing Tables and Queries.. is
that why you call me a wimp?

I use a platform that runs circles around you kids.

Billions of records with sub-second response times.
Don't sit around and talk shit just because your obsolete MDB bullshit
can't scale to a million records.



Lyle Fairfield wrote:

Lyle Fairfield wrote:

db*******@hotmail.com wrote:

I am much better at Access AND Sql than anyone i've
ever seen on this newsgroup.

We're all grateful that you have shared your expertise here in CDMA.
But some of us may have missed one or two of your better contributions.
Would you list the links to a few, say ten, of your creative and
original posts so that we can reference them as a small library of
excellence?

In addition, this may help us to remember to maintain the appropriate
level of deferential integrity in our discussions with you.

Better yet why not create a compendium of these wonderful ideas in an
SQL-Server Table with code and descriptions in Text fields? You could
then create and make freely available an ADP which would allow us all
to access your wonderful ideas. I'm sure, that you, as El Supremo
ADP/SQL can craft your application in such a way that there will be no
security breaches or concerns.
In that way you can not only show, but also demonstrate the magnificent
qualities of the ADP. What an opportunity!

[Keith Wilby]

"Andrew R" <an*************@cashette.com> wrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...

How a simple question has exploded!

Information AND entertainment - don't you just love newsgroups?!

:-)
Andrew

You should be around when "PC Datasheet" is here. Actually, both
trouble-making parties should really be ignored but sometimes some of us
give in to temptation too easily ;-)

Keith.

[dbahooker]

no self respect?

at least I dont use a PUSSY database engine

uh compact and repair?
in the year 2006?

GAG

grow some balls kids and stop fighting for the pink team


Terry Kreft wrote:

Ha, ha, ha, it's just marvellous how you have not the slightest piece of
self-respect.

Please continue to show us how wonderful you are<g>; I've quite given up
reading Dilbert as your contributions are so much more originally funny.

You might not know much about programming (except in your world of course)
but you certainly know how to amuse!

I've only seen one piece of code from you and it was so laughably wrong but
far too subtle I thought, most people probably thought you meant it to be
like that.
--

Terry Kreft
<db*******@hotmail.com> wrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...

Terry;

screw yourself; I am much better at Access AND Sql than anyone i've
ever seen on this newsgroup.

And most importantly; I dont just blindly use the first tool the comes
across my desk.

I use the best tool for whatever I am doing.

Most of your idiots are unnecessarily biased agasint Access Data
Projects.
I find that laughable.
-Aaron
Terry Kreft wrote:

I love the way that you have no compunction about showing how ignorant you are of both transact SQL and Access SQL and the way that you're not afraid of displaying your stupidity in public is really marvelous.
--

Terry Kreft
<aa*********@gmail.com> wrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...
> good stuff
>
>
> IF EXISTS (SELECT TOP 1 'X' FROM newsgroup WHERE tool_of_choice =
> 'MDB')
> BEGIN
> RAISERROR ('oh wait a second mdb can't handle real tsql
> statements; it is for babies', 16, 127, 'horsecrap')
> END
>
>
>
>
>
>
> Terry Kreft wrote:
> > IF EXISTS (SELECT * FROM newsgroup WHERE user_name = 'aaron')
> > BEGIN
> > DELETE FROM newsgroup WHERE user_name = 'aaron'
> > RAISERROR ('Troll alert - %d talking garbage', 16, 127, 'aaron')
> > END
> >
> >
> > --
> >
> > Terry Kreft
> >
> >
> > <aa*********@gmail.com> wrote in message
> > news:11*********************@u72g2000cwu.googlegro ups.com...
> > > fucking retards
> > >
> > > SQL Server is more powerful
> > > anyone that uses MDB in the year 2006?
> > >
> > > you should spit on them.
> > > out of the blue; just walk up to them and spit.
> > >
> > > you can have constraints-- you can have triggers-- you can have custom > > > dataTypes
> > >
> > >
> > >
> > >
> > > rkc wrote:
> > > > Jamie Collins wrote:
> > > > > rkc wrote:
> > > > >
> > > > >>What does SQL have to do with referential integrity?
> > > > >
> > > > >
> > > > > http://en.wikipedia.org/wiki/SQL
> > > > >
> > > > > See the 'Concepts' section.
> > > >
> > > > I didn't see any mention of SQL in the Referential Integrity
> > > > entry under that topic.
> > >
>

[Terry Kreft]

LOL, your wit almost exceeds your demonstrated technical ability.

With considered demonstrable arguments such as this I don't see how anyone
could possibly disagree.

--

Terry Kreft
<db*******@hotmail.com> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...

Terry

fuck yourself

Terry Kreft wrote:

Ha, ha, ha, it's just marvellous how you have not the slightest piece of self-respect.

Please continue to show us how wonderful you are<g>; I've quite given up reading Dilbert as your contributions are so much more originally funny.

You might not know much about programming (except in your world of course) but you certainly know how to amuse!

I've only seen one piece of code from you and it was so laughably wrong but far too subtle I thought, most people probably thought you meant it to be like that.
--

Terry Kreft
<db*******@hotmail.com> wrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...

Terry;

screw yourself; I am much better at Access AND Sql than anyone i've
ever seen on this newsgroup.

And most importantly; I dont just blindly use the first tool the comes
across my desk.

I use the best tool for whatever I am doing.

Most of your idiots are unnecessarily biased agasint Access Data
Projects.
I find that laughable.
-Aaron
Terry Kreft wrote:
> I love the way that you have no compunction about showing how ignorant

you

> are of both transact SQL and Access SQL and the way that you're not

afraid

> of displaying your stupidity in public is really marvelous.
>
>
> --
>
> Terry Kreft
>
>
> <aa*********@gmail.com> wrote in message
> news:11**********************@p79g2000cwp.googlegr oups.com...
> > good stuff
> >
> >
> > IF EXISTS (SELECT TOP 1 'X' FROM newsgroup WHERE tool_of_choice =
> > 'MDB')
> > BEGIN
> > RAISERROR ('oh wait a second mdb can't handle real tsql
> > statements; it is for babies', 16, 127, 'horsecrap')
> > END
> >
> >
> >
> >
> >
> >
> > Terry Kreft wrote:
> > > IF EXISTS (SELECT * FROM newsgroup WHERE user_name = 'aaron')
> > > BEGIN
> > > DELETE FROM newsgroup WHERE user_name = 'aaron'
> > > RAISERROR ('Troll alert - %d talking garbage', 16, 127,

'aaron') > > > END
> > >
> > >
> > > --
> > >
> > > Terry Kreft
> > >
> > >
> > > <aa*********@gmail.com> wrote in message
> > > news:11*********************@u72g2000cwu.googlegro ups.com...
> > > > fucking retards
> > > >
> > > > SQL Server is more powerful
> > > > anyone that uses MDB in the year 2006?
> > > >
> > > > you should spit on them.
> > > > out of the blue; just walk up to them and spit.
> > > >
> > > > you can have constraints-- you can have triggers-- you can

have custom

> > > > dataTypes
> > > >
> > > >
> > > >
> > > >
> > > > rkc wrote:
> > > > > Jamie Collins wrote:
> > > > > > rkc wrote:
> > > > > >
> > > > > >>What does SQL have to do with referential integrity?
> > > > > >
> > > > > >
> > > > > > http://en.wikipedia.org/wiki/SQL
> > > > > >
> > > > > > See the 'Concepts' section.
> > > > >
> > > > > I didn't see any mention of SQL in the Referential Integrity
> > > > > entry under that topic.
> > > >
> >

[Lyle Fairfield]

db*******@hotmail.com wrote:

for the record

sql server security is a LOT better than your silly MDB bullshit.

can you kids even prevent me from updating a single table?

I'm sorry that you idiots try to TALK_SHIT about people just because
they're willing to think OUTSIDE THE BOX.

Just because I dont have to compact and repair my database every 3
days?? that makes me less of a man?

Because I dont spend half my time re-syncing Tables and Queries.. is
that why you call me a wimp?

I use a platform that runs circles around you kids.

Billions of records with sub-second response times.
Don't sit around and talk shit just because your obsolete MDB bullshit
can't scale to a million records.

Is that a No? You mean you won't share your expertise? What a shame!

[Terry Kreft]

I think you've got a spurious ? in there on the first line, wasn't that
meant to be a statement?

To be honest I'm not sure which database engine you do use as you've done
such a good job of obfuscating your technical ability, I know which one you
claim, but then we can all claim anything we want, can't we.

--

Terry Kreft
<db*******@hotmail.com> wrote in message
news:11**********************@y41g2000cwy.googlegr oups.com...

no self respect?

at least I dont use a PUSSY database engine

uh compact and repair?
in the year 2006?

GAG

grow some balls kids and stop fighting for the pink team


Terry Kreft wrote:

Ha, ha, ha, it's just marvellous how you have not the slightest piece of self-respect.

Please continue to show us how wonderful you are<g>; I've quite given up reading Dilbert as your contributions are so much more originally funny.

You might not know much about programming (except in your world of course) but you certainly know how to amuse!

I've only seen one piece of code from you and it was so laughably wrong but far too subtle I thought, most people probably thought you meant it to be like that.
--

Terry Kreft
<db*******@hotmail.com> wrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...

Terry;

screw yourself; I am much better at Access AND Sql than anyone i've
ever seen on this newsgroup.

And most importantly; I dont just blindly use the first tool the comes
across my desk.

I use the best tool for whatever I am doing.

Most of your idiots are unnecessarily biased agasint Access Data
Projects.
I find that laughable.
-Aaron
Terry Kreft wrote:
> I love the way that you have no compunction about showing how ignorant

you

> are of both transact SQL and Access SQL and the way that you're not

afraid

> of displaying your stupidity in public is really marvelous.
>
>
> --
>
> Terry Kreft
>
>
> <aa*********@gmail.com> wrote in message
> news:11**********************@p79g2000cwp.googlegr oups.com...
> > good stuff
> >
> >
> > IF EXISTS (SELECT TOP 1 'X' FROM newsgroup WHERE tool_of_choice =
> > 'MDB')
> > BEGIN
> > RAISERROR ('oh wait a second mdb can't handle real tsql
> > statements; it is for babies', 16, 127, 'horsecrap')
> > END
> >
> >
> >
> >
> >
> >
> > Terry Kreft wrote:
> > > IF EXISTS (SELECT * FROM newsgroup WHERE user_name = 'aaron')
> > > BEGIN
> > > DELETE FROM newsgroup WHERE user_name = 'aaron'
> > > RAISERROR ('Troll alert - %d talking garbage', 16, 127,

'aaron') > > > END
> > >
> > >
> > > --
> > >
> > > Terry Kreft
> > >
> > >
> > > <aa*********@gmail.com> wrote in message
> > > news:11*********************@u72g2000cwu.googlegro ups.com...
> > > > fucking retards
> > > >
> > > > SQL Server is more powerful
> > > > anyone that uses MDB in the year 2006?
> > > >
> > > > you should spit on them.
> > > > out of the blue; just walk up to them and spit.
> > > >
> > > > you can have constraints-- you can have triggers-- you can

have custom

> > > > dataTypes
> > > >
> > > >
> > > >
> > > >
> > > > rkc wrote:
> > > > > Jamie Collins wrote:
> > > > > > rkc wrote:
> > > > > >
> > > > > >>What does SQL have to do with referential integrity?
> > > > > >
> > > > > >
> > > > > > http://en.wikipedia.org/wiki/SQL
> > > > > >
> > > > > > See the 'Concepts' section.
> > > > >
> > > > > I didn't see any mention of SQL in the Referential Integrity
> > > > > entry under that topic.
> > > >
> >

[Terry Kreft]

Keith,
Didn't your mother ever warn you not to invoke Trolls by name ?

<g>

--

Terry Kreft
"Keith Wilby" <he**@there.com> wrote in message
news:44**********@glkas0286.greenlnk.net...

"Andrew R" <an*************@cashette.com> wrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...

How a simple question has exploded!

Information AND entertainment - don't you just love newsgroups?!

:-)
Andrew

You should be around when "XX XATASHEET" is here. Actually, both
trouble-making parties should really be ignored but sometimes some of us
give in to temptation too easily ;-)

Keith.

[Keith Wilby]

"Terry Kreft" <te*********@mps.co.uk> wrote in message
news:eM**************@TK2MSFTNGP02.phx.gbl...

Keith,
Didn't your mother ever warn you not to invoke Trolls by name ?

<g>

My mistake m'lud. :-) It has been awfully quiet on that front and I quite
like it.

[Terry Kreft]

It's funny though, isn't it, how some trolls are amusing, especially when
they're trying to be obnoxious and others are just plain obnoxious?

--

Terry Kreft
"Keith Wilby" <he**@there.com> wrote in message
news:44**********@glkas0286.greenlnk.net...

"Terry Kreft" <te*********@mps.co.uk> wrote in message
news:eM**************@TK2MSFTNGP02.phx.gbl...

Keith,
Didn't your mother ever warn you not to invoke Trolls by name ?

<g>

My mistake m'lud. :-) It has been awfully quiet on that front and I quite
like it.

[Lyle Fairfield]

Terry Kreft wrote:

It's funny though, isn't it, how some trolls are amusing, especially when
they're trying to be obnoxious and others are just plain obnoxious?

IIRC Aaron has made some helpful and informative posts in ADP groups. A
year or so ago he seemed more temperate, reasoned and capable, ...
even. But, he's not contributing much any more; he hasn't even
introduced me to any new "words". Life goes on.

[aaron.kempf]

SQL RI works across the 2gb limit and the 2gb limit in Access??

I can sneeze and make 2gb of data out of it.

I've seen spreadsheets that hit the 2gb limit. i mean for christ sakes.

you can't rely on RI in an MDB.. not for only 2 tables with 2 records
each and only 2 users.

in practical implementations; it is impossible to do.

-Aaron
Jamie Collins wrote:

rkc wrote:

Referential integrity is not an SQL concept.
It's a relational database design concept.

You got it in the end!

To relate back your original enquiry, 'What does SQL have to do with
referential integrity?' If you want declarative referential integrity,
SQL's got it (Jet SQL's got it so I guess you can say Access's got it
too).

HTH,
Jamie.

--

[David W. Fenton]

"Terry Kreft" <te*********@mps.co.uk> wrote in
news:45********************@karoo.co.uk:

It's funny though, isn't it, how some trolls are amusing,
especially when they're trying to be obnoxious and others are just
plain obnoxious?

Amusement is in the eye of the beholder.

This beholder's eyes are complete devoid of any amusement.

If you give a rat's ass.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[Terry Kreft]

In the eye of the beholder is Amusement.

Devoid of any amusement this beholder's eyes are complete.

If you give a rat's ass.
--

Terry Kreft
"David W. Fenton" <XX*******@dfenton.com.invalid> wrote in message
news:Xn**********************************@127.0.0. 1...

"Terry Kreft" <te*********@mps.co.uk> wrote in
news:45********************@karoo.co.uk:

It's funny though, isn't it, how some trolls are amusing,
especially when they're trying to be obnoxious and others are just
plain obnoxious?

Amusement is in the eye of the beholder.

This beholder's eyes are complete devoid of any amusement.

If you give a rat's ass.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[Jamie Collins]

aa*********@gmail.com wrote:

SQL [Server] RI works across the 2gb limit

File size (and other limits) aside, DRI is better implemented in Jet
4.0 than in SQL Server 2005 e.g. try this simple example:

CREATE TABLE OrgChart (
employee_number INTEGER NOT NULL PRIMARY KEY,
boss INTEGER
REFERENCES OrgChart (employee_number)
ON DELETE CASCADE
ON UPDATE CASCADE
);

SQL Server 2005 worries that this 'may cause cycles or multiple cascade
paths' when even a moron (e.g. Jet 4.0) can figure it out.

Do I choose Jet over SQL Server because its implementation is better in
some areas e.g. DRI, CHECK constraints, etc? Of course not.

The fact remains that I sometimes design DRI/CHECKs in Jet 4.0 before
having to 'dumb down' for SQL Server 2005 e.g. a trigger with the
comment 'Replace this trigger with proper functionality when the SQL
Server team stop obsessing over CLR and get round finishing the
implementation of the SQL-92 standard, or at least get as smarts as
Access was FIVE years ago.'

Jamie.

--

[Arno R]

<aa*********@gmail.com> schreef in bericht news:11**********************@u72g2000cwu.googlegr oups.com...

SQL RI works across the 2gb limit and the 2gb limit in Access??

I can sneeze and make 2gb of data out of it.

I've seen spreadsheets that hit the 2gb limit. i mean for christ sakes.

you can't rely on RI in an MDB.. not for only 2 tables with 2 records
each and only 2 users.

in practical implementations; it is impossible to do.

-Aaron

Can't you just get lost with your horsecrap ??

BTW: Horsecrap *is* your language isn't it ??

Arno R

[aaron.kempf]

Terry;

it is so hilarious that you guys sit around and defend an obsolete
database format.. that is TEN YEARS out of date.

Grow some balls and lose the training wheels; kids.

Access Data Projects _SLAUGHTERS_ MDB format. It slaughters ACCDB
format also.

-Aaron
Terry Kreft wrote:

I love the way that you have no compunction about showing how ignorant you
are of both transact SQL and Access SQL and the way that you're not afraid
of displaying your stupidity in public is really marvelous.
--

Terry Kreft
<aa*********@gmail.com> wrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...

good stuff
IF EXISTS (SELECT TOP 1 'X' FROM newsgroup WHERE tool_of_choice =
'MDB')
BEGIN
RAISERROR ('oh wait a second mdb can't handle real tsql
statements; it is for babies', 16, 127, 'horsecrap')
END


Terry Kreft wrote:

IF EXISTS (SELECT * FROM newsgroup WHERE user_name = 'aaron')
BEGIN
DELETE FROM newsgroup WHERE user_name = 'aaron'
RAISERROR ('Troll alert - %d talking garbage', 16, 127, 'aaron')
END
--

Terry Kreft
<aa*********@gmail.com> wrote in message
news:11*********************@u72g2000cwu.googlegro ups.com...
> fucking retards
>
> SQL Server is more powerful
> anyone that uses MDB in the year 2006?
>
> you should spit on them.
> out of the blue; just walk up to them and spit.
>
> you can have constraints-- you can have triggers-- you can have custom
> dataTypes
>
>
>
>
> rkc wrote:
> > Jamie Collins wrote:
> > > rkc wrote:
> > >
> > >>What does SQL have to do with referential integrity?
> > >
> > >
> > > http://en.wikipedia.org/wiki/SQL
> > >
> > > See the 'Concepts' section.
> >
> > I didn't see any mention of SQL in the Referential Integrity
> > entry under that topic.
>

[Terry Kreft]

Oh, are you back?

I thought that you had possibly gone off to learn a new tune, or at least
add anoher string to your bow.

It's obvious that you haven't been for an eye-test, as every problem is
still looking like a nail to you.

--

Terry Kreft
<aa*********@gmail.com> wrote in message
news:11**********************@c74g2000cwc.googlegr oups.com...

Terry;

it is so hilarious that you guys sit around and defend an obsolete
database format.. that is TEN YEARS out of date.

Grow some balls and lose the training wheels; kids.

Access Data Projects _SLAUGHTERS_ MDB format. It slaughters ACCDB
format also.

-Aaron
Terry Kreft wrote:

I love the way that you have no compunction about showing how ignorant you are of both transact SQL and Access SQL and the way that you're not afraid of displaying your stupidity in public is really marvelous.
--

Terry Kreft
<aa*********@gmail.com> wrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...

good stuff
IF EXISTS (SELECT TOP 1 'X' FROM newsgroup WHERE tool_of_choice =
'MDB')
BEGIN
RAISERROR ('oh wait a second mdb can't handle real tsql
statements; it is for babies', 16, 127, 'horsecrap')
END


Terry Kreft wrote:
> IF EXISTS (SELECT * FROM newsgroup WHERE user_name = 'aaron')
> BEGIN
> DELETE FROM newsgroup WHERE user_name = 'aaron'
> RAISERROR ('Troll alert - %d talking garbage', 16, 127, 'aaron')
> END
>
>
> --
>
> Terry Kreft
>
>
> <aa*********@gmail.com> wrote in message
> news:11*********************@u72g2000cwu.googlegro ups.com...
> > fucking retards
> >
> > SQL Server is more powerful
> > anyone that uses MDB in the year 2006?
> >
> > you should spit on them.
> > out of the blue; just walk up to them and spit.
> >
> > you can have constraints-- you can have triggers-- you can have custom > > dataTypes
> >
> >
> >
> >
> > rkc wrote:
> > > Jamie Collins wrote:
> > > > rkc wrote:
> > > >
> > > >>What does SQL have to do with referential integrity?
> > > >
> > > >
> > > > http://en.wikipedia.org/wiki/SQL
> > > >
> > > > See the 'Concepts' section.
> > >
> > > I didn't see any mention of SQL in the Referential Integrity
> > > entry under that topic.
> >

[Keith Wilby]

<aa*********@gmail.com> wrote in message
news:11**********************@c74g2000cwc.googlegr oups.com...

Grow some balls

I shounds like you lost yoursh in a terrible shmelting accident.

[dbahooker]

you guys are a bunch of assholes and dipshits

just because I speak the truth-- that MDB is obsolete-- it doesn't mean
that I'm a troll.

you guys need to get a life; grow some balls and use a real database
engine
Terry Kreft wrote:

I think you've got a spurious ? in there on the first line, wasn't that
meant to be a statement?

To be honest I'm not sure which database engine you do use as you've done
such a good job of obfuscating your technical ability, I know which one you
claim, but then we can all claim anything we want, can't we.

--

Terry Kreft
<db*******@hotmail.com> wrote in message
news:11**********************@y41g2000cwy.googlegr oups.com...

no self respect?

at least I dont use a PUSSY database engine

uh compact and repair?
in the year 2006?

GAG

grow some balls kids and stop fighting for the pink team


Terry Kreft wrote:

Ha, ha, ha, it's just marvellous how you have not the slightest piece of self-respect.

Please continue to show us how wonderful you are<g>; I've quite given up reading Dilbert as your contributions are so much more originally funny.

You might not know much about programming (except in your world of course) but you certainly know how to amuse!

I've only seen one piece of code from you and it was so laughably wrong but far too subtle I thought, most people probably thought you meant it to be like that.
--

Terry Kreft
<db*******@hotmail.com> wrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...
> Terry;
>
> screw yourself; I am much better at Access AND Sql than anyone i've
> ever seen on this newsgroup.
>
> And most importantly; I dont just blindly use the first tool the comes
> across my desk.
>
> I use the best tool for whatever I am doing.
>
> Most of your idiots are unnecessarily biased agasint Access Data
> Projects.
> I find that laughable.
>
>
> -Aaron
>
>
> Terry Kreft wrote:
> > I love the way that you have no compunction about showing how ignorant you
> > are of both transact SQL and Access SQL and the way that you're not
afraid
> > of displaying your stupidity in public is really marvelous.
> >
> >
> > --
> >
> > Terry Kreft
> >
> >
> > <aa*********@gmail.com> wrote in message
> > news:11**********************@p79g2000cwp.googlegr oups.com...
> > > good stuff
> > >
> > >
> > > IF EXISTS (SELECT TOP 1 'X' FROM newsgroup WHERE tool_of_choice =
> > > 'MDB')
> > > BEGIN
> > > RAISERROR ('oh wait a second mdb can't handle real tsql
> > > statements; it is for babies', 16, 127, 'horsecrap')
> > > END
> > >
> > >
> > >
> > >
> > >
> > >
> > > Terry Kreft wrote:
> > > > IF EXISTS (SELECT * FROM newsgroup WHERE user_name = 'aaron')
> > > > BEGIN
> > > > DELETE FROM newsgroup WHERE user_name = 'aaron'
> > > > RAISERROR ('Troll alert - %d talking garbage', 16, 127, 'aaron') > > > > END
> > > >
> > > >
> > > > --
> > > >
> > > > Terry Kreft
> > > >
> > > >
> > > > <aa*********@gmail.com> wrote in message
> > > > news:11*********************@u72g2000cwu.googlegro ups.com...
> > > > > fucking retards
> > > > >
> > > > > SQL Server is more powerful
> > > > > anyone that uses MDB in the year 2006?
> > > > >
> > > > > you should spit on them.
> > > > > out of the blue; just walk up to them and spit.
> > > > >
> > > > > you can have constraints-- you can have triggers-- you can have custom
> > > > > dataTypes
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > rkc wrote:
> > > > > > Jamie Collins wrote:
> > > > > > > rkc wrote:
> > > > > > >
> > > > > > >>What does SQL have to do with referential integrity?
> > > > > > >
> > > > > > >
> > > > > > > http://en.wikipedia.org/wiki/SQL
> > > > > > >
> > > > > > > See the 'Concepts' section.
> > > > > >
> > > > > > I didn't see any mention of SQL in the Referential Integrity
> > > > > > entry under that topic.
> > > > >
> > >
>

[Craig Alexander Morrison]

I use Access and DB2 -- ADPs are obsolete.

However I am glad you like them, I used to but as I could not use them to
access DB2 what was the point of them, they tied you to SQL Server, which is
not the brightest kid in the class even weaker in some respects than Jet 4.

BTW DB2 Express-C is free and is very very good, I remember you were abusive
to me about that a few months back and I forgot to mention it did not cost
thousands of dollars as you alleged. Free to develop, deploy and distribute.

Your abusive posts are no doubt the result of frustration about the demise
of ADPs, but you do not see me and others being abusive about people who use
SQL Server 2005.

Craig Alexander Morrison
Crawbridge Data (Scotland) Limited
<db*******@hotmail.com> wrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...

you guys are a bunch of assholes and dipshits

just because I speak the truth-- that MDB is obsolete-- it doesn't mean
that I'm a troll.

you guys need to get a life; grow some balls and use a real database
engine
Terry Kreft wrote:

I think you've got a spurious ? in there on the first line, wasn't that
meant to be a statement?

To be honest I'm not sure which database engine you do use as you've done
such a good job of obfuscating your technical ability, I know which one
you
claim, but then we can all claim anything we want, can't we.

--

Terry Kreft
<db*******@hotmail.com> wrote in message
news:11**********************@y41g2000cwy.googlegr oups.com...

> no self respect?
>
> at least I dont use a PUSSY database engine
>
> uh compact and repair?
> in the year 2006?
>
> GAG
>
> grow some balls kids and stop fighting for the pink team
>
>
>
>
> Terry Kreft wrote:
> > Ha, ha, ha, it's just marvellous how you have not the slightest
> > piece

of

> > self-respect.
> >
> > Please continue to show us how wonderful you are<g>; I've quite
> > given

up

> > reading Dilbert as your contributions are so much more originally
> > funny.
> >
> > You might not know much about programming (except in your world of

course)

> > but you certainly know how to amuse!
> >
> > I've only seen one piece of code from you and it was so laughably
> > wrong

but

> > far too subtle I thought, most people probably thought you meant it
> > to

be

> > like that.
> >
> >
> > --
> >
> > Terry Kreft
> >
> >
> > <db*******@hotmail.com> wrote in message
> > news:11**********************@p79g2000cwp.googlegr oups.com...
> > > Terry;
> > >
> > > screw yourself; I am much better at Access AND Sql than anyone i've
> > > ever seen on this newsgroup.
> > >
> > > And most importantly; I dont just blindly use the first tool the
> > > comes
> > > across my desk.
> > >
> > > I use the best tool for whatever I am doing.
> > >
> > > Most of your idiots are unnecessarily biased agasint Access Data
> > > Projects.
> > > I find that laughable.
> > >
> > >
> > > -Aaron
> > >
> > >
> > > Terry Kreft wrote:
> > > > I love the way that you have no compunction about showing how

ignorant

> > you
> > > > are of both transact SQL and Access SQL and the way that you're
> > > > not
> > afraid
> > > > of displaying your stupidity in public is really marvelous.
> > > >
> > > >
> > > > --
> > > >
> > > > Terry Kreft
> > > >
> > > >
> > > > <aa*********@gmail.com> wrote in message
> > > > news:11**********************@p79g2000cwp.googlegr oups.com...
> > > > > good stuff
> > > > >
> > > > >
> > > > > IF EXISTS (SELECT TOP 1 'X' FROM newsgroup WHERE
> > > > > tool_of_choice =
> > > > > 'MDB')
> > > > > BEGIN
> > > > > RAISERROR ('oh wait a second mdb can't handle real tsql
> > > > > statements; it is for babies', 16, 127, 'horsecrap')
> > > > > END
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Terry Kreft wrote:
> > > > > > IF EXISTS (SELECT * FROM newsgroup WHERE user_name = 'aaron')
> > > > > > BEGIN
> > > > > > DELETE FROM newsgroup WHERE user_name = 'aaron'
> > > > > > RAISERROR ('Troll alert - %d talking garbage', 16, 127,

'aaron')

> > > > > > END
> > > > > >
> > > > > >
> > > > > > --
> > > > > >
> > > > > > Terry Kreft
> > > > > >
> > > > > >
> > > > > > <aa*********@gmail.com> wrote in message
> > > > > > news:11*********************@u72g2000cwu.googlegro ups.com...
> > > > > > > fucking retards
> > > > > > >
> > > > > > > SQL Server is more powerful
> > > > > > > anyone that uses MDB in the year 2006?
> > > > > > >
> > > > > > > you should spit on them.
> > > > > > > out of the blue; just walk up to them and spit.
> > > > > > >
> > > > > > > you can have constraints-- you can have triggers-- you can

have

> > custom
> > > > > > > dataTypes
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > rkc wrote:
> > > > > > > > Jamie Collins wrote:
> > > > > > > > > rkc wrote:
> > > > > > > > >
> > > > > > > > >>What does SQL have to do with referential integrity?
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > http://en.wikipedia.org/wiki/SQL
> > > > > > > > >
> > > > > > > > > See the 'Concepts' section.
> > > > > > > >
> > > > > > > > I didn't see any mention of SQL in the Referential
> > > > > > > > Integrity
> > > > > > > > entry under that topic.
> > > > > > >
> > > > >
> > >
>

[Craig Alexander Morrison]

I use Access and DB2 -- ADPs are obsolete.

However I am glad you like them, I used to but as I could not use them to
access DB2 what was the point of them, they tied you to SQL Server, which is
not the brightest kid in the class even weaker in some respects than Jet 4.

BTW DB2 Express-C is free and is very very good, I remember you were abusive
to me about that a few months back and I forgot to mention it did not cost
thousands of dollars as you alleged. Free to develop, deploy and distribute.

Your abusive posts are no doubt the result of frustration about the demise
of ADPs, but you do not see me and others being abusive about people who use
SQL Server 2005.

Craig Alexander Morrison
Crawbridge Data (Scotland) Limited

<db*******@hotmail.com> wrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...

you guys are a bunch of ...

just because I speak the truth-- that MDB is obsolete-- it doesn't mean
that I'm a troll.

you guys need to get a life; grow some balls and use a real database
engine

[Lyle Fairfield]

Craig Alexander Morrison wrote:

I use Access and DB2 -- ADPs are obsolete.

Could you expand?

How do you connect?

Your forms and reports are bound?

How do you manage the DB2 database?

What are storage limits?

Can you use on a web-site and/or across the internet?

What's good/not so good?

[Craig Alexander Morrison]

> Could you expand?

I will.
How do you connect?
I connect via ODBC.
Your forms and reports are bound?
Yes
How do you manage the DB2 database?
The database is managed using the DB2 Control Center or the DB2 CLP (command
line processor, this is groovy (wg) if you grew up with the DOS Prompt.)

There are also a whole set of other tools such as the Development Center to
design SQL PL (stored procedures), The Activity Monitor for runtime
analysis, Design Analysis to check the database design, Visual Explain which
displays Access Plan Graphs, Health Center can be used on the databases but
this is only available in ESE environments. There are also loads of wizards,
the one I think is the best is the Automatic Maintenance configuration
wizard, reduces the role of DBA to a minimum.
What are storage limits?

Can you use on a web-site and/or across the internet?
Yes. Although I have not used it in this way.

DB2 Express-C is based on the same core technology as the DB2 Universal
DatabaseT (UDB) Express Edition V8.2.2 product. DB2 Express-C is available
on Linux® and Windows® platforms (32- and 64-bit) as a no-charge download
from IBM. IBM introduced DB2 Express-C, a version of DB2 Universal Database
Express Edition (DB2 Express), for the community on January 30, 2006. It
offers a solid base to build and deploy all applications, including C/C++,
Java, .NET, PHP, and more.
What's good
It's not SQL Server 2005 (g).

It's rock solid.
not so good?

There is little downside they only limits on the free version is it can only
use 4GB or memory and up to 2 CPUs.

It does not include the High Availability and Disaster Recovery functions,
but this does give it a lighter footprint than DB2 Express.
--
Slainte

Craig Alexander Morrison
Crawbridge Data (Scotland) Limited
"Lyle Fairfield" <ly***********@aim.com> wrote in message
news:11**********************@b68g2000cwa.googlegr oups.com... Craig Alexander Morrison wrote:

I use Access and DB2 -- ADPs are obsolete.

[Bri]

db*******@hotmail.com wrote:

just because I speak the truth-- that MDB is obsolete-- it doesn't mean
that I'm a troll.

What ever truth there may be in your assertions is lost in the vitriol
of your writing style. That is what makes you a troll.

--
Bri

[aaron.kempf]

Craig;

you're a fucking idiot and a liar.

SQL Server runs the worlds' largest databases.

When was the last time that DB2 won a price/performance on tpc.org??

SQL Server rocks dude; you're so full of crap.

I do not have abusive posts.
I just deal with a bunch of close-minded people that won't give ADP a
chance.

ADP are the best platform anywhere.

Running them against SQL 2005 is the most pleasant experience I've ever
had.

You don't have enough balls to talk shit about SQL 2005 because you're
fighting for the wrong team.

IBM is a bunch of dinosaurs; I mean seriously here-- Oracle has at
least a little bit of punch.

And for the record; you CAN use DB2 inside of ADP.
It's DEAD simple kid.

MUCH MUCH MUCH better platform than MDB.

-Aaron


Craig Alexander Morrison wrote:

I use Access and DB2 -- ADPs are obsolete.

However I am glad you like them, I used to but as I could not use them to
access DB2 what was the point of them, they tied you to SQL Server, which is
not the brightest kid in the class even weaker in some respects than Jet 4.

BTW DB2 Express-C is free and is very very good, I remember you were abusive
to me about that a few months back and I forgot to mention it did not cost
thousands of dollars as you alleged. Free to develop, deploy and distribute.

Your abusive posts are no doubt the result of frustration about the demise
of ADPs, but you do not see me and others being abusive about people who use
SQL Server 2005.

Craig Alexander Morrison
Crawbridge Data (Scotland) Limited

<db*******@hotmail.com> wrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...

you guys are a bunch of ...

just because I speak the truth-- that MDB is obsolete-- it doesn't mean
that I'm a troll.

you guys need to get a life; grow some balls and use a real database
engine

[Terry Kreft]

Ha, ha, ha the old ones are always the best.

You're not a Troll, snigger!

Seriously though, you shouldn't deny your nature, that way lies deep
unhappiness. Next you'll be railing against lifes little problems and
blowing them up out of all proportion, even worse you might start thinking
strange things like, your truth is the only truth and that anyone who
doesn't agrre with you is stupid and things.

Anyway you take care until we talk again.

--

Terry Kreft
<db*******@hotmail.com> wrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...

you guys are a bunch of assholes and dipshits

just because I speak the truth-- that MDB is obsolete-- it doesn't mean
that I'm a troll.

you guys need to get a life; grow some balls and use a real database
engine
Terry Kreft wrote:

I think you've got a spurious ? in there on the first line, wasn't that
meant to be a statement?

To be honest I'm not sure which database engine you do use as you've done such a good job of obfuscating your technical ability, I know which one you claim, but then we can all claim anything we want, can't we.

--

Terry Kreft
<db*******@hotmail.com> wrote in message
news:11**********************@y41g2000cwy.googlegr oups.com...

no self respect?

at least I dont use a PUSSY database engine

uh compact and repair?
in the year 2006?

GAG

grow some balls kids and stop fighting for the pink team


Terry Kreft wrote:
> Ha, ha, ha, it's just marvellous how you have not the slightest piece

of

> self-respect.
>
> Please continue to show us how wonderful you are<g>; I've quite

given up

> reading Dilbert as your contributions are so much more originally

funny. >
> You might not know much about programming (except in your world of

course)

> but you certainly know how to amuse!
>
> I've only seen one piece of code from you and it was so laughably wrong but

> far too subtle I thought, most people probably thought you meant it

to be

> like that.
>
>
> --
>
> Terry Kreft
>
>
> <db*******@hotmail.com> wrote in message
> news:11**********************@p79g2000cwp.googlegr oups.com...
> > Terry;
> >
> > screw yourself; I am much better at Access AND Sql than anyone

i've > > ever seen on this newsgroup.
> >
> > And most importantly; I dont just blindly use the first tool the comes > > across my desk.
> >
> > I use the best tool for whatever I am doing.
> >
> > Most of your idiots are unnecessarily biased agasint Access Data
> > Projects.
> > I find that laughable.
> >
> >
> > -Aaron
> >
> >
> > Terry Kreft wrote:
> > > I love the way that you have no compunction about showing how

ignorant

> you
> > > are of both transact SQL and Access SQL and the way that you're not > afraid
> > > of displaying your stupidity in public is really marvelous.
> > >
> > >
> > > --
> > >
> > > Terry Kreft
> > >
> > >
> > > <aa*********@gmail.com> wrote in message
> > > news:11**********************@p79g2000cwp.googlegr oups.com...
> > > > good stuff
> > > >
> > > >
> > > > IF EXISTS (SELECT TOP 1 'X' FROM newsgroup WHERE tool_of_choice = > > > > 'MDB')
> > > > BEGIN
> > > > RAISERROR ('oh wait a second mdb can't handle real tsql
> > > > statements; it is for babies', 16, 127, 'horsecrap')
> > > > END
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Terry Kreft wrote:
> > > > > IF EXISTS (SELECT * FROM newsgroup WHERE user_name = 'aaron') > > > > > BEGIN
> > > > > DELETE FROM newsgroup WHERE user_name = 'aaron'
> > > > > RAISERROR ('Troll alert - %d talking garbage', 16, 127,

'aaron')

> > > > > END
> > > > >
> > > > >
> > > > > --
> > > > >
> > > > > Terry Kreft
> > > > >
> > > > >
> > > > > <aa*********@gmail.com> wrote in message
> > > > > news:11*********************@u72g2000cwu.googlegro ups.com...
> > > > > > fucking retards
> > > > > >
> > > > > > SQL Server is more powerful
> > > > > > anyone that uses MDB in the year 2006?
> > > > > >
> > > > > > you should spit on them.
> > > > > > out of the blue; just walk up to them and spit.
> > > > > >
> > > > > > you can have constraints-- you can have triggers-- you can

have

> custom
> > > > > > dataTypes
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > rkc wrote:
> > > > > > > Jamie Collins wrote:
> > > > > > > > rkc wrote:
> > > > > > > >
> > > > > > > >>What does SQL have to do with referential integrity?
> > > > > > > >
> > > > > > > >
> > > > > > > > http://en.wikipedia.org/wiki/SQL
> > > > > > > >
> > > > > > > > See the 'Concepts' section.
> > > > > > >
> > > > > > > I didn't see any mention of SQL in the Referential Integrity > > > > > > > entry under that topic.
> > > > > >
> > > >
> >

[Craig Alexander Morrison]

> What are storage limits?

I am not sure but I think it is whatever you want. I know you can arrange to
spread your database over different disk drives. I am still getting to know
this version of DB2 so my advice to anyone reading this is check the details
at the ibm website,

http://www-306.ibm.com/software/data...db/db2express/

When I first saw the DB2 Express-C documents it read along the lines that
unlike SQL Server 2005 Express and Oracle Express it had no abitrary limits
other than the 4GB memory and 2 CPUs.

As to ADPs well I used them against SQL Server 2000 but lost all hope when I
saw what they were doing to SQL Server 2005 so looked around for an
alternative and DB2 was it, it was just my good luck that the Express-C was
released around then.
--
Slainte

Craig Alexander Morrison
Crawbridge Data (Scotland) Limited
"Lyle Fairfield" <ly***********@aim.com> wrote in message
news:11**********************@b68g2000cwa.googlegr oups.com... Craig Alexander Morrison wrote:

I use Access and DB2 -- ADPs are obsolete.

Could you expand?

[Lyle Fairfield]

Thanks! Something new to try, then.

[trollstomper]

Man!! That idiot troll dbahooker / aaron kempf /phil must have escaped from someone's funny farm! Has anyone ever noticed how the mental midget never ever provides examples of what he is ranitng about??

By the way, dear little dbahooker / aaron kempf / phil himself admitted that Microsoft fired him. I wonder why???? :rolleyes:

Check out the other 99 forums and newsgroups he posts in..... it's all the same crap - of how great he is, of how everything sucks, of how his ways are the only ways, along with his 4-letter mentality.

Hey, Aaron.... since your car got stolen at Microsoft, get on your bicycle (the one with the training wheels) and pebble your butt away...... far away!