dbTalk Databases Forums  

One last issue in DB: Can't update text

comp.databases.ms-access comp.databases.ms-access


Discuss One last issue in DB: Can't update text in the comp.databases.ms-access forum.

Reply
 
Thread Tools Display Modes
  #11  
Old   
aaron.kempf@gmail.com
 
Posts: n/a

Default Re: One last issue in DB: Can't update text - 03-19-2009 , 02:19 PM






BECAUSE OF THE FACT THAT IT IS IMPOSSIBLE TO SECURE JET, you should
try to use a database that supports security -- for everything that
you do.

Again.. SQL Server development is _EASIER_ than Jet.
Again.. SQL Server development is _EASIER_ than Jet.
Again.. SQL Server development is _EASIER_ than Jet.
That's what you don't understand.
That's what you don't understand.
That's what you don't understand.

-Aaron



On Mar 19, 7:30*am, "BruceM" <bam... (AT) yawhodotcalm (DOT) not> wrote:
Quote:
Go ahead and advocate SQL server for everything down to balancing a
checkbook if you must, but stuff the name calling.

aaron.ke... (AT) gmail (DOT) com> wrote in message

news:694fd8a3-7739-45ba-a9ff-926480221686 (AT) y38g2000prg (DOT) googlegroups.com...
dude you're a moron.

you're putting mountains of logic in queries-- where you need 100
copies of it--
instead of putting logic where it belongs-- on the database server.

Do you honestly think that Jet can handle 12m records?

ROFL good luck with that dude

I used to have a dozen 1m tables, in about 60 distinct applications
running in jet.
I hated it-- it doesn't work well enough.

Upsize to SQL Server and things just work

-Aaron

On Mar 18, 12:57 pm, chickenfriedsteak <ow... (AT) chickenfriedsteak (DOT) us
wrote:



On Mar 18, 3:43 pm, "bcap" <b... (AT) nospam (DOT) nowhere> wrote:> One of us has
omitted the closing quotation marks on the last line, which
should read as follows:

Me.Combo17 & """")

n.b. yes, that really is *four* double-quote marks!

(Snip)

YARGGHHH! that fixed it.

I haven't done this much hassling and cussing at quotation marks since
the last time I had to touch something in C++.- Hide quoted text -

- Show quoted text -




Reply With Quote
  #12  
Old   
BruceM
 
Posts: n/a

Default Re: One last issue in DB: Can't update text - 03-20-2009 , 05:14 AM






I said to stop with the name calling. Your response, as is typical, is
irrelevant.

<aaron.kempf (AT) gmail (DOT) com> wrote

BECAUSE OF THE FACT THAT IT IS IMPOSSIBLE TO SECURE JET, you should
try to use a database that supports security -- for everything that
you do.

Again.. SQL Server development is _EASIER_ than Jet.
Again.. SQL Server development is _EASIER_ than Jet.
Again.. SQL Server development is _EASIER_ than Jet.
That's what you don't understand.
That's what you don't understand.
That's what you don't understand.

-Aaron



On Mar 19, 7:30 am, "BruceM" <bam... (AT) yawhodotcalm (DOT) not> wrote:
Quote:
Go ahead and advocate SQL server for everything down to balancing a
checkbook if you must, but stuff the name calling.

aaron.ke... (AT) gmail (DOT) com> wrote in message

news:694fd8a3-7739-45ba-a9ff-926480221686 (AT) y38g2000prg (DOT) googlegroups.com...
dude you're a moron.

you're putting mountains of logic in queries-- where you need 100
copies of it--
instead of putting logic where it belongs-- on the database server.

Do you honestly think that Jet can handle 12m records?

ROFL good luck with that dude

I used to have a dozen 1m tables, in about 60 distinct applications
running in jet.
I hated it-- it doesn't work well enough.

Upsize to SQL Server and things just work

-Aaron

On Mar 18, 12:57 pm, chickenfriedsteak <ow... (AT) chickenfriedsteak (DOT) us
wrote:



On Mar 18, 3:43 pm, "bcap" <b... (AT) nospam (DOT) nowhere> wrote:> One of us has
omitted the closing quotation marks on the last line, which
should read as follows:

Me.Combo17 & """")

n.b. yes, that really is *four* double-quote marks!

(Snip)

YARGGHHH! that fixed it.

I haven't done this much hassling and cussing at quotation marks since
the last time I had to touch something in C++.- Hide quoted text -

- Show quoted text -


Reply With Quote
  #13  
Old   
Terry Kreft
 
Posts: n/a

Default Re: One last issue in DB: Can't update text - 03-20-2009 , 07:09 AM



He, he it's nice to see that I can pop out for a few months and some things
stay the same in here, Aaron the troll is still wearing his blinkers and
thinks that a hammer can do the job of a screwdriver.

Again: Correct tool for the job
Again: Correct tool for the job
Again: Correct tool for the job
That's what you don't understand.
That's what you don't understand.
That's what you don't understand.


Terry Kreft


<aaron.kempf (AT) gmail (DOT) com> wrote

BECAUSE OF THE FACT THAT IT IS IMPOSSIBLE TO SECURE JET, you should
try to use a database that supports security -- for everything that
you do.

Again.. SQL Server development is _EASIER_ than Jet.
Again.. SQL Server development is _EASIER_ than Jet.
Again.. SQL Server development is _EASIER_ than Jet.
That's what you don't understand.
That's what you don't understand.
That's what you don't understand.

-Aaron



On Mar 19, 7:30 am, "BruceM" <bam... (AT) yawhodotcalm (DOT) not> wrote:
Quote:
Go ahead and advocate SQL server for everything down to balancing a
checkbook if you must, but stuff the name calling.

aaron.ke... (AT) gmail (DOT) com> wrote in message

news:694fd8a3-7739-45ba-a9ff-926480221686 (AT) y38g2000prg (DOT) googlegroups.com...
dude you're a moron.

you're putting mountains of logic in queries-- where you need 100
copies of it--
instead of putting logic where it belongs-- on the database server.

Do you honestly think that Jet can handle 12m records?

ROFL good luck with that dude

I used to have a dozen 1m tables, in about 60 distinct applications
running in jet.
I hated it-- it doesn't work well enough.

Upsize to SQL Server and things just work

-Aaron

On Mar 18, 12:57 pm, chickenfriedsteak <ow... (AT) chickenfriedsteak (DOT) us
wrote:



On Mar 18, 3:43 pm, "bcap" <b... (AT) nospam (DOT) nowhere> wrote:> One of us has
omitted the closing quotation marks on the last line, which
should read as follows:

Me.Combo17 & """")

n.b. yes, that really is *four* double-quote marks!

(Snip)

YARGGHHH! that fixed it.

I haven't done this much hassling and cussing at quotation marks since
the last time I had to touch something in C++.- Hide quoted text -

- Show quoted text -



Reply With Quote
  #14  
Old   
Tony Toews [MVP]
 
Posts: n/a

Default Re: One last issue in DB: Can't update text - 03-20-2009 , 02:21 PM



chickenfriedsteak <owner (AT) chickenfriedsteak (DOT) us> wrote:

Quote:
Sorry to bug the list so much, I
We don't mind you posting questions. That's what we enjoy doing. Please continue to
ask questions.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/


Reply With Quote
  #15  
Old   
aaron.kempf@gmail.com
 
Posts: n/a

Default Re: One last issue in DB: Can't update text - 03-23-2009 , 03:22 PM



uh, you're the one with a hammer and you think that everything should
be done with an obsolete database
uh, you're the one with a hammer and you think that everything should
be done with an obsolete database
uh, you're the one with a hammer and you think that everything should
be done with an obsolete database




On Mar 20, 6:09*am, "Terry Kreft" <d... (AT) spam (DOT) me.co.uk> wrote:
Quote:
He, he it's nice to see that I can pop out for a few months and some things
stay the same in here, Aaron the troll is still wearing his blinkers and
thinks that a hammer can do the job of a screwdriver.

Again: Correct tool for the job
Again: Correct tool for the job
Again: Correct tool for the job
That's what you don't understand.
That's what you don't understand.
That's what you don't understand.

Terry Kreft

aaron.ke... (AT) gmail (DOT) com> wrote in message

news:d8f5ff16-bbac-405b-96a4-97ea6ae4a911 (AT) d19g2000prh (DOT) googlegroups.com...
BECAUSE OF THE FACT THAT IT IS IMPOSSIBLE TO SECURE JET, you should
try to use a database that supports security -- for everything that
you do.

Again.. SQL Server development is _EASIER_ than Jet.
Again.. SQL Server development is _EASIER_ than Jet.
Again.. SQL Server development is _EASIER_ than Jet.
That's what you don't understand.
That's what you don't understand.
That's what you don't understand.

-Aaron

On Mar 19, 7:30 am, "BruceM" <bam... (AT) yawhodotcalm (DOT) not> wrote:

Go ahead and advocate SQL server for everything down to balancing a
checkbook if you must, but stuff the name calling.

aaron.ke... (AT) gmail (DOT) com> wrote in message

news:694fd8a3-7739-45ba-a9ff-926480221686 (AT) y38g2000prg (DOT) googlegroups.com....
dude you're a moron.

you're putting mountains of logic in queries-- where you need 100
copies of it--
instead of putting logic where it belongs-- on the database server.

Do you honestly think that Jet can handle 12m records?

ROFL good luck with that dude

I used to have a dozen 1m tables, in about 60 distinct applications
running in jet.
I hated it-- it doesn't work well enough.

Upsize to SQL Server and things just work

-Aaron

On Mar 18, 12:57 pm, chickenfriedsteak <ow... (AT) chickenfriedsteak (DOT) us
wrote:

On Mar 18, 3:43 pm, "bcap" <b... (AT) nospam (DOT) nowhere> wrote:> One of us has
omitted the closing quotation marks on the last line, which
should read as follows:

Me.Combo17 & """")

n.b. yes, that really is *four* double-quote marks!

(Snip)

YARGGHHH! that fixed it.

I haven't done this much hassling and cussing at quotation marks since
the last time I had to touch something in C++.- Hide quoted text -

- Show quoted text -


Reply With Quote
  #16  
Old   
Terry Kreft
 
Posts: n/a

Default Re: One last issue in DB: Can't update text - 03-23-2009 , 04:10 PM



Ha, ha, ha, oh you get better every time.

See if you can see the irony in there Aaron, no, ok I'll explain it to you.

Every answer you give is the same; 'insult Access/JET ... use SQL server ...
insult OP ...' hence you are using the same tool for every job, do you get
it now?

Again: Correct tool for the job
Again: Correct tool for the job
Again: Correct tool for the job
That's what you don't understand.
That's what you don't understand.
That's what you don't understand.


Terry Kreft


<aaron.kempf (AT) gmail (DOT) com> wrote

uh, you're the one with a hammer and you think that everything should
be done with an obsolete database
uh, you're the one with a hammer and you think that everything should
be done with an obsolete database
uh, you're the one with a hammer and you think that everything should
be done with an obsolete database




On Mar 20, 6:09 am, "Terry Kreft" <d... (AT) spam (DOT) me.co.uk> wrote:
Quote:
He, he it's nice to see that I can pop out for a few months and some
things
stay the same in here, Aaron the troll is still wearing his blinkers and
thinks that a hammer can do the job of a screwdriver.

Again: Correct tool for the job
Again: Correct tool for the job
Again: Correct tool for the job
That's what you don't understand.
That's what you don't understand.
That's what you don't understand.

Terry Kreft

aaron.ke... (AT) gmail (DOT) com> wrote in message

news:d8f5ff16-bbac-405b-96a4-97ea6ae4a911 (AT) d19g2000prh (DOT) googlegroups.com...
BECAUSE OF THE FACT THAT IT IS IMPOSSIBLE TO SECURE JET, you should
try to use a database that supports security -- for everything that
you do.

Again.. SQL Server development is _EASIER_ than Jet.
Again.. SQL Server development is _EASIER_ than Jet.
Again.. SQL Server development is _EASIER_ than Jet.
That's what you don't understand.
That's what you don't understand.
That's what you don't understand.

-Aaron

On Mar 19, 7:30 am, "BruceM" <bam... (AT) yawhodotcalm (DOT) not> wrote:

Go ahead and advocate SQL server for everything down to balancing a
checkbook if you must, but stuff the name calling.

aaron.ke... (AT) gmail (DOT) com> wrote in message

news:694fd8a3-7739-45ba-a9ff-926480221686 (AT) y38g2000prg (DOT) googlegroups.com...
dude you're a moron.

you're putting mountains of logic in queries-- where you need 100
copies of it--
instead of putting logic where it belongs-- on the database server.

Do you honestly think that Jet can handle 12m records?

ROFL good luck with that dude

I used to have a dozen 1m tables, in about 60 distinct applications
running in jet.
I hated it-- it doesn't work well enough.

Upsize to SQL Server and things just work

-Aaron

On Mar 18, 12:57 pm, chickenfriedsteak <ow... (AT) chickenfriedsteak (DOT) us
wrote:

On Mar 18, 3:43 pm, "bcap" <b... (AT) nospam (DOT) nowhere> wrote:> One of us has
omitted the closing quotation marks on the last line, which
should read as follows:

Me.Combo17 & """")

n.b. yes, that really is *four* double-quote marks!

(Snip)

YARGGHHH! that fixed it.

I haven't done this much hassling and cussing at quotation marks since
the last time I had to touch something in C++.- Hide quoted text -

- Show quoted text -



Reply With Quote
  #17  
Old   
Terry Kreft
 
Posts: n/a

Default Re: One last issue in DB: Can't update text - 03-24-2009 , 07:39 AM



Aaron,
You seem really confused here; I have never said that SQL Server is never
the right solution, I certainly have never shouted that, you though have
said the opposite on a number of occasions, see your reply below for an
example of this.

Looking in my toolbox I have a hammer, a screwdriver, a nail punch, some
screws and some nails, oh and one of those tools everyone inherits from
their dad but isn't quite sure what it's for.

Now, personally, I don't want to get sodomized at all, although I'm aware
that some people do enjoy this and good luck to them if they can get it I
say, what I do want is to look at a problem, come up with the best solution
to that problem and then implement that solution.

You could only possibly prefer direct client server because the projects you
have been involved in were quite small, anybody with any real experience
would prefer some indirection in the structure so that changes in
implementation can easily take place.

Again you seem to have the wrong end of the stick here Aaron, I'm not trying
to boss you around, I just think it's quite amusing that you still don't
seem to have got the idea yet that one solution (SQL Server) is not the only
solution.


Terry Kreft


<aaron.kempf (AT) gmail (DOT) com> wrote

Terry;

you're the one that's saying that 'SQL SERVER IS NEVER THE RIGHT
SOLUTION BECAUSE JET IS ALWAYS THE RIGHT SOLUTION'.
You're the one with a hammer.. and everything looks like a nail
(because all you've got is a hammer).

JET IS _NEVER_ THE RIGHT SOLUTION BECAUSE IT"S NOT STABLE.

SQL Server is _EASIER_ it is _CHEAPER_ it is _FASTER_ and it is
_BETTER_.

Build it nice or build it twice.
It's your choice.. do you want to be sodomized by SQL Server directly,
or would you prefer to get sodomized by SharePoint and _THEN_ SQL
Server?

It's all about the number of layers...
I prefer direct client-server-- because it's more powerful, and it's
easier to troubleshoot.

When Jet gets basic PROFILER capabilities, is when you can try to boss
me around!

-Aaron



On Mar 23, 3:10 pm, "Terry Kreft" <d... (AT) spam (DOT) me.co.uk> wrote:
Quote:
Ha, ha, ha, oh you get better every time.

See if you can see the irony in there Aaron, no, ok I'll explain it to
you.

Every answer you give is the same; 'insult Access/JET ... use SQL server
...
insult OP ...' hence you are using the same tool for every job, do you get
it now?

Again: Correct tool for the job
Again: Correct tool for the job
Again: Correct tool for the job
That's what you don't understand.
That's what you don't understand.
That's what you don't understand.

Terry Kreft

aaron.ke... (AT) gmail (DOT) com> wrote in message

news:14cf8e23-904c-494c-a8fc-e4c85a39cd69 (AT) n7g2000prc (DOT) googlegroups.com...
uh, you're the one with a hammer and you think that everything should
be done with an obsolete database
uh, you're the one with a hammer and you think that everything should
be done with an obsolete database
uh, you're the one with a hammer and you think that everything should
be done with an obsolete database

On Mar 20, 6:09 am, "Terry Kreft" <d... (AT) spam (DOT) me.co.uk> wrote:



He, he it's nice to see that I can pop out for a few months and some
things
stay the same in here, Aaron the troll is still wearing his blinkers and
thinks that a hammer can do the job of a screwdriver.

Again: Correct tool for the job
Again: Correct tool for the job
Again: Correct tool for the job
That's what you don't understand.
That's what you don't understand.
That's what you don't understand.

Terry Kreft

aaron.ke... (AT) gmail (DOT) com> wrote in message

news:d8f5ff16-bbac-405b-96a4-97ea6ae4a911 (AT) d19g2000prh (DOT) googlegroups.com...
BECAUSE OF THE FACT THAT IT IS IMPOSSIBLE TO SECURE JET, you should
try to use a database that supports security -- for everything that
you do.

Again.. SQL Server development is _EASIER_ than Jet.
Again.. SQL Server development is _EASIER_ than Jet.
Again.. SQL Server development is _EASIER_ than Jet.
That's what you don't understand.
That's what you don't understand.
That's what you don't understand.

-Aaron

On Mar 19, 7:30 am, "BruceM" <bam... (AT) yawhodotcalm (DOT) not> wrote:

Go ahead and advocate SQL server for everything down to balancing a
checkbook if you must, but stuff the name calling.

aaron.ke... (AT) gmail (DOT) com> wrote in message

news:694fd8a3-7739-45ba-a9ff-926480221686 (AT) y38g2000prg (DOT) googlegroups.com...
dude you're a moron.

you're putting mountains of logic in queries-- where you need 100
copies of it--
instead of putting logic where it belongs-- on the database server.

Do you honestly think that Jet can handle 12m records?

ROFL good luck with that dude

I used to have a dozen 1m tables, in about 60 distinct applications
running in jet.
I hated it-- it doesn't work well enough.

Upsize to SQL Server and things just work

-Aaron

On Mar 18, 12:57 pm, chickenfriedsteak <ow... (AT) chickenfriedsteak (DOT) us
wrote:

On Mar 18, 3:43 pm, "bcap" <b... (AT) nospam (DOT) nowhere> wrote:> One of us
has
omitted the closing quotation marks on the last line, which
should read as follows:

Me.Combo17 & """")

n.b. yes, that really is *four* double-quote marks!

(Snip)

YARGGHHH! that fixed it.

I haven't done this much hassling and cussing at quotation marks
since
the last time I had to touch something in C++.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -



Reply With Quote
  #18  
Old   
Salad
 
Posts: n/a

Default Re: One last issue in DB: Can't update text - 03-24-2009 , 11:53 AM



Terry Kreft wrote:

Quote:
Aaron,
You seem really confused here; I have never said that SQL Server is never
the right solution, I certainly have never shouted that, you though have
said the opposite on a number of occasions, see your reply below for an
example of this.

Looking in my toolbox I have a hammer, a screwdriver, a nail punch, some
screws and some nails, oh and one of those tools everyone inherits from
their dad but isn't quite sure what it's for.

Now, personally, I don't want to get sodomized at all, although I'm aware
that some people do enjoy this and good luck to them if they can get it I
say, what I do want is to look at a problem, come up with the best solution
to that problem and then implement that solution.

You could only possibly prefer direct client server because the projects you
have been involved in were quite small, anybody with any real experience
would prefer some indirection in the structure so that changes in
implementation can easily take place.

Again you seem to have the wrong end of the stick here Aaron, I'm not trying
to boss you around, I just think it's quite amusing that you still don't
seem to have got the idea yet that one solution (SQL Server) is not the only
solution.


Terry Kreft


aaron.kempf (AT) gmail (DOT) com> wrote in message
news:cf4eb257-6307-48b0-9745-d358e690c3af (AT) p42g2000prp (DOT) googlegroups.com...
Terry;

you're the one that's saying that 'SQL SERVER IS NEVER THE RIGHT
SOLUTION BECAUSE JET IS ALWAYS THE RIGHT SOLUTION'.
You're the one with a hammer.. and everything looks like a nail
(because all you've got is a hammer).

JET IS _NEVER_ THE RIGHT SOLUTION BECAUSE IT"S NOT STABLE.

SQL Server is _EASIER_ it is _CHEAPER_ it is _FASTER_ and it is
_BETTER_.

Build it nice or build it twice.
It's your choice.. do you want to be sodomized by SQL Server directly,
or would you prefer to get sodomized by SharePoint and _THEN_ SQL
Server?

It's all about the number of layers...
I prefer direct client-server-- because it's more powerful, and it's
easier to troubleshoot.

When Jet gets basic PROFILER capabilities, is when you can try to boss
me around!

-Aaron



On Mar 23, 3:10 pm, "Terry Kreft" <d... (AT) spam (DOT) me.co.uk> wrote:

Ha, ha, ha, oh you get better every time.

See if you can see the irony in there Aaron, no, ok I'll explain it to
you.

Every answer you give is the same; 'insult Access/JET ... use SQL server
...
insult OP ...' hence you are using the same tool for every job, do you get
it now?

Again: Correct tool for the job
Again: Correct tool for the job
Again: Correct tool for the job
That's what you don't understand.
That's what you don't understand.
That's what you don't understand.

Terry Kreft

aaron.ke... (AT) gmail (DOT) com> wrote in message

news:14cf8e23-904c-494c-a8fc-e4c85a39cd69 (AT) n7g2000prc (DOT) googlegroups.com...
uh, you're the one with a hammer and you think that everything should
be done with an obsolete database
uh, you're the one with a hammer and you think that everything should
be done with an obsolete database
uh, you're the one with a hammer and you think that everything should
be done with an obsolete database

On Mar 20, 6:09 am, "Terry Kreft" <d... (AT) spam (DOT) me.co.uk> wrote:




He, he it's nice to see that I can pop out for a few months and some
things
stay the same in here, Aaron the troll is still wearing his blinkers and
thinks that a hammer can do the job of a screwdriver.

Again: Correct tool for the job
Again: Correct tool for the job
Again: Correct tool for the job
That's what you don't understand.
That's what you don't understand.
That's what you don't understand.

Terry Kreft

aaron.ke... (AT) gmail (DOT) com> wrote in message

news:d8f5ff16-bbac-405b-96a4-97ea6ae4a911 (AT) d19g2000prh (DOT) googlegroups.com...
BECAUSE OF THE FACT THAT IT IS IMPOSSIBLE TO SECURE JET, you should
try to use a database that supports security -- for everything that
you do.

Again.. SQL Server development is _EASIER_ than Jet.
Again.. SQL Server development is _EASIER_ than Jet.
Again.. SQL Server development is _EASIER_ than Jet.
That's what you don't understand.
That's what you don't understand.
That's what you don't understand.

-Aaron

On Mar 19, 7:30 am, "BruceM" <bam... (AT) yawhodotcalm (DOT) not> wrote:

Go ahead and advocate SQL server for everything down to balancing a
checkbook if you must, but stuff the name calling.

aaron.ke... (AT) gmail (DOT) com> wrote in message

news:694fd8a3-7739-45ba-a9ff-926480221686 (AT) y38g2000prg (DOT) googlegroups.com...
dude you're a moron.

you're putting mountains of logic in queries-- where you need 100
copies of it--
instead of putting logic where it belongs-- on the database server.

Do you honestly think that Jet can handle 12m records?

ROFL good luck with that dude

I used to have a dozen 1m tables, in about 60 distinct applications
running in jet.
I hated it-- it doesn't work well enough.

Upsize to SQL Server and things just work

-Aaron

On Mar 18, 12:57 pm, chickenfriedsteak <ow... (AT) chickenfriedsteak (DOT) us
wrote:

On Mar 18, 3:43 pm, "bcap" <b... (AT) nospam (DOT) nowhere> wrote:> One of us
has
omitted the closing quotation marks on the last line, which

should read as follows:

Me.Combo17 & """")

n.b. yes, that really is *four* double-quote marks!

(Snip)

YARGGHHH! that fixed it.

I haven't done this much hassling and cussing at quotation marks
since
the last time I had to touch something in C++.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Damn, it's been a while since I've seen your name in a post. I guess
you are in the microsoft groups.


Reply With Quote
  #19  
Old   
Terry Kreft
 
Posts: n/a

Default Re: One last issue in DB: Can't update text - 03-24-2009 , 06:26 PM



Hi Salad,
No, I've just left a job which seemed to take up just about all of my time
for the last couple of years so I've been very inactive in the NGs. I've
just popped in really to have a quick nose at what people are asking about
and couldn't resist the temptation to rehash this discussion with Aaron.


Terry Kreft


"Salad" <oil (AT) vinegar (DOT) com> wrote

Quote:
Terry Kreft wrote:

Aaron,
You seem really confused here; I have never said that SQL Server is never
the right solution, I certainly have never shouted that, you though have
said the opposite on a number of occasions, see your reply below for an
example of this.

Looking in my toolbox I have a hammer, a screwdriver, a nail punch, some
screws and some nails, oh and one of those tools everyone inherits from
their dad but isn't quite sure what it's for.

Now, personally, I don't want to get sodomized at all, although I'm aware
that some people do enjoy this and good luck to them if they can get it I
say, what I do want is to look at a problem, come up with the best
solution to that problem and then implement that solution.

You could only possibly prefer direct client server because the projects
you have been involved in were quite small, anybody with any real
experience would prefer some indirection in the structure so that changes
in implementation can easily take place.

Again you seem to have the wrong end of the stick here Aaron, I'm not
trying to boss you around, I just think it's quite amusing that you still
don't seem to have got the idea yet that one solution (SQL Server) is not
the only solution.


Terry Kreft


aaron.kempf (AT) gmail (DOT) com> wrote in message
news:cf4eb257-6307-48b0-9745-d358e690c3af (AT) p42g2000prp (DOT) googlegroups.com...
Terry;

you're the one that's saying that 'SQL SERVER IS NEVER THE RIGHT
SOLUTION BECAUSE JET IS ALWAYS THE RIGHT SOLUTION'.
You're the one with a hammer.. and everything looks like a nail
(because all you've got is a hammer).

JET IS _NEVER_ THE RIGHT SOLUTION BECAUSE IT"S NOT STABLE.

SQL Server is _EASIER_ it is _CHEAPER_ it is _FASTER_ and it is
_BETTER_.

Build it nice or build it twice.
It's your choice.. do you want to be sodomized by SQL Server directly,
or would you prefer to get sodomized by SharePoint and _THEN_ SQL
Server?

It's all about the number of layers...
I prefer direct client-server-- because it's more powerful, and it's
easier to troubleshoot.

When Jet gets basic PROFILER capabilities, is when you can try to boss
me around!

-Aaron



On Mar 23, 3:10 pm, "Terry Kreft" <d... (AT) spam (DOT) me.co.uk> wrote:

Ha, ha, ha, oh you get better every time.

See if you can see the irony in there Aaron, no, ok I'll explain it to
you.

Every answer you give is the same; 'insult Access/JET ... use SQL server
...
insult OP ...' hence you are using the same tool for every job, do you
get
it now?

Again: Correct tool for the job
Again: Correct tool for the job
Again: Correct tool for the job
That's what you don't understand.
That's what you don't understand.
That's what you don't understand.

Terry Kreft

aaron.ke... (AT) gmail (DOT) com> wrote in message

news:14cf8e23-904c-494c-a8fc-e4c85a39cd69 (AT) n7g2000prc (DOT) googlegroups.com...
uh, you're the one with a hammer and you think that everything should
be done with an obsolete database
uh, you're the one with a hammer and you think that everything should
be done with an obsolete database
uh, you're the one with a hammer and you think that everything should
be done with an obsolete database

On Mar 20, 6:09 am, "Terry Kreft" <d... (AT) spam (DOT) me.co.uk> wrote:




He, he it's nice to see that I can pop out for a few months and some
things
stay the same in here, Aaron the troll is still wearing his blinkers and
thinks that a hammer can do the job of a screwdriver.

Again: Correct tool for the job
Again: Correct tool for the job
Again: Correct tool for the job
That's what you don't understand.
That's what you don't understand.
That's what you don't understand.

Terry Kreft

aaron.ke... (AT) gmail (DOT) com> wrote in message

news:d8f5ff16-bbac-405b-96a4-97ea6ae4a911 (AT) d19g2000prh (DOT) googlegroups.com...
BECAUSE OF THE FACT THAT IT IS IMPOSSIBLE TO SECURE JET, you should
try to use a database that supports security -- for everything that
you do.

Again.. SQL Server development is _EASIER_ than Jet.
Again.. SQL Server development is _EASIER_ than Jet.
Again.. SQL Server development is _EASIER_ than Jet.
That's what you don't understand.
That's what you don't understand.
That's what you don't understand.

-Aaron

On Mar 19, 7:30 am, "BruceM" <bam... (AT) yawhodotcalm (DOT) not> wrote:

Go ahead and advocate SQL server for everything down to balancing a
checkbook if you must, but stuff the name calling.

aaron.ke... (AT) gmail (DOT) com> wrote in message

news:694fd8a3-7739-45ba-a9ff-926480221686 (AT) y38g2000prg (DOT) googlegroups.com...
dude you're a moron.

you're putting mountains of logic in queries-- where you need 100
copies of it--
instead of putting logic where it belongs-- on the database server.

Do you honestly think that Jet can handle 12m records?

ROFL good luck with that dude

I used to have a dozen 1m tables, in about 60 distinct applications
running in jet.
I hated it-- it doesn't work well enough.

Upsize to SQL Server and things just work

-Aaron

On Mar 18, 12:57 pm, chickenfriedsteak <ow... (AT) chickenfriedsteak (DOT) us
wrote:

On Mar 18, 3:43 pm, "bcap" <b... (AT) nospam (DOT) nowhere> wrote:> One of us has
omitted the closing quotation marks on the last line, which

should read as follows:

Me.Combo17 & """")

n.b. yes, that really is *four* double-quote marks!

(Snip)

YARGGHHH! that fixed it.

I haven't done this much hassling and cussing at quotation marks since
the last time I had to touch something in C++.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -


Damn, it's been a while since I've seen your name in a post. I guess you
are in the microsoft groups.



Reply With Quote
  #20  
Old   
Salad
 
Posts: n/a

Default Re: One last issue in DB: Can't update text - 03-24-2009 , 07:46 PM






Terry Kreft wrote:
Quote:
Hi Salad,
No, I've just left a job which seemed to take up just about all of my time
for the last couple of years so I've been very inactive in the NGs. I've
just popped in really to have a quick nose at what people are asking about
and couldn't resist the temptation to rehash this discussion with Aaron.


Terry Kreft
Hi Terry,

It's nice to see a regular again. Even if this time it turns out to be
a short visit, remember your roots.




Quote:

"Salad" <oil (AT) vinegar (DOT) com> wrote in message
news:geqdnToTcba7g1TUnZ2dnUVZ_vCdnZ2d (AT) earthlink (DOT) com...

Terry Kreft wrote:


Aaron,
You seem really confused here; I have never said that SQL Server is never
the right solution, I certainly have never shouted that, you though have
said the opposite on a number of occasions, see your reply below for an
example of this.

Looking in my toolbox I have a hammer, a screwdriver, a nail punch, some
screws and some nails, oh and one of those tools everyone inherits from
their dad but isn't quite sure what it's for.

Now, personally, I don't want to get sodomized at all, although I'm aware
that some people do enjoy this and good luck to them if they can get it I
say, what I do want is to look at a problem, come up with the best
solution to that problem and then implement that solution.

You could only possibly prefer direct client server because the projects
you have been involved in were quite small, anybody with any real
experience would prefer some indirection in the structure so that changes
in implementation can easily take place.

Again you seem to have the wrong end of the stick here Aaron, I'm not
trying to boss you around, I just think it's quite amusing that you still
don't seem to have got the idea yet that one solution (SQL Server) is not
the only solution.


Terry Kreft


aaron.kempf (AT) gmail (DOT) com> wrote in message
news:cf4eb257-6307-48b0-9745-d358e690c3af (AT) p42g2000prp (DOT) googlegroups.com...
Terry;

you're the one that's saying that 'SQL SERVER IS NEVER THE RIGHT
SOLUTION BECAUSE JET IS ALWAYS THE RIGHT SOLUTION'.
You're the one with a hammer.. and everything looks like a nail
(because all you've got is a hammer).

JET IS _NEVER_ THE RIGHT SOLUTION BECAUSE IT"S NOT STABLE.

SQL Server is _EASIER_ it is _CHEAPER_ it is _FASTER_ and it is
_BETTER_.

Build it nice or build it twice.
It's your choice.. do you want to be sodomized by SQL Server directly,
or would you prefer to get sodomized by SharePoint and _THEN_ SQL
Server?

It's all about the number of layers...
I prefer direct client-server-- because it's more powerful, and it's
easier to troubleshoot.

When Jet gets basic PROFILER capabilities, is when you can try to boss
me around!

-Aaron



On Mar 23, 3:10 pm, "Terry Kreft" <d... (AT) spam (DOT) me.co.uk> wrote:


Ha, ha, ha, oh you get better every time.

See if you can see the irony in there Aaron, no, ok I'll explain it to
you.

Every answer you give is the same; 'insult Access/JET ... use SQL server
...
insult OP ...' hence you are using the same tool for every job, do you
get
it now?

Again: Correct tool for the job
Again: Correct tool for the job
Again: Correct tool for the job
That's what you don't understand.
That's what you don't understand.
That's what you don't understand.

Terry Kreft

aaron.ke... (AT) gmail (DOT) com> wrote in message

news:14cf8e23-904c-494c-a8fc-e4c85a39cd69 (AT) n7g2000prc (DOT) googlegroups.com...
uh, you're the one with a hammer and you think that everything should
be done with an obsolete database
uh, you're the one with a hammer and you think that everything should
be done with an obsolete database
uh, you're the one with a hammer and you think that everything should
be done with an obsolete database

On Mar 20, 6:09 am, "Terry Kreft" <d... (AT) spam (DOT) me.co.uk> wrote:





He, he it's nice to see that I can pop out for a few months and some
things
stay the same in here, Aaron the troll is still wearing his blinkers and
thinks that a hammer can do the job of a screwdriver.

Again: Correct tool for the job
Again: Correct tool for the job
Again: Correct tool for the job
That's what you don't understand.
That's what you don't understand.
That's what you don't understand.

Terry Kreft

aaron.ke... (AT) gmail (DOT) com> wrote in message

news:d8f5ff16-bbac-405b-96a4-97ea6ae4a911 (AT) d19g2000prh (DOT) googlegroups.com...
BECAUSE OF THE FACT THAT IT IS IMPOSSIBLE TO SECURE JET, you should
try to use a database that supports security -- for everything that
you do.

Again.. SQL Server development is _EASIER_ than Jet.
Again.. SQL Server development is _EASIER_ than Jet.
Again.. SQL Server development is _EASIER_ than Jet.
That's what you don't understand.
That's what you don't understand.
That's what you don't understand.

-Aaron

On Mar 19, 7:30 am, "BruceM" <bam... (AT) yawhodotcalm (DOT) not> wrote:

Go ahead and advocate SQL server for everything down to balancing a
checkbook if you must, but stuff the name calling.

aaron.ke... (AT) gmail (DOT) com> wrote in message

news:694fd8a3-7739-45ba-a9ff-926480221686 (AT) y38g2000prg (DOT) googlegroups.com...
dude you're a moron.

you're putting mountains of logic in queries-- where you need 100
copies of it--
instead of putting logic where it belongs-- on the database server.

Do you honestly think that Jet can handle 12m records?

ROFL good luck with that dude

I used to have a dozen 1m tables, in about 60 distinct applications
running in jet.
I hated it-- it doesn't work well enough.

Upsize to SQL Server and things just work

-Aaron

On Mar 18, 12:57 pm, chickenfriedsteak <ow... (AT) chickenfriedsteak (DOT) us
wrote:

On Mar 18, 3:43 pm, "bcap" <b... (AT) nospam (DOT) nowhere> wrote:> One of us has
omitted the closing quotation marks on the last line, which


should read as follows:

Me.Combo17 & """")

n.b. yes, that really is *four* double-quote marks!

(Snip)

YARGGHHH! that fixed it.

I haven't done this much hassling and cussing at quotation marks since
the last time I had to touch something in C++.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Damn, it's been a while since I've seen your name in a post. I guess you
are in the microsoft groups.




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.