[AccessD] Expert's Exchange; new program

[Jim Dettman]

Bill,

 I'd be careful with that; GIGO.

 ChatGPT can give some nonsense errors in some very subtle ways.  I know a number of people that ask it to do coding on a regular basis, and while the simple stuff is pretty good, with anything complex, it can easily turn out a poor/junk answer.  i.e. it will work, but no one in their right mind would code it that way.  There also was a demonstration where complete garbage was fed in intentionally to a model, and it of course spit out junk as a result.    That's something that people really need to think about.   No one can verify all the data being fed into these things, and what gets spit out may or may not be grounded in fact.

 ChatGPT also doesn't give you a real-world view in many cases as well.   I answered a question on EE about FTP from Access and suggested WinSCP, a batch file with the commands, a command file to execute the batch, calling the command file with Shell() from VBA, and then parsing the log file for success/failure.  Another member responded that it was over engineered, and you could do it all with a single command line, which was the Chat GPT answer as well.

  Thing is, I've lived with having to maintain and troubleshoot FTP connections for a very long time, and the reason I break it down like that is:

1. I can look at the batch, command, and log files after executing (they are left behind when a failure occurs).
2. I can execute the batch and command files outside of Access.
3. I can issue the command line manually to test.
4. I can issue the batch file commands one by one in the client manually to test.

 With all that, I can troubleshoot an FTP connection within a matter of minutes and figure out what the problem is.   Real world experience counts for something, which ChatGPT doesn't always capture.     

 Buzzword of the day is "AI", and everyone is trying to use it, but I think many jump in without fully realizing the limitations.    We're also have the problem now of when given an answer, you don't know how you arrived at that answer.     It is good, don't get me wrong, but it's good only to a point, and it's only as good as the data fed into it. 

 I think it will help people in many ways, I just think we are all jumping in a little too fast before fully understanding what it can and can't do for us. 

caveat emptor

Jim.

-----Original Message-----
From: AccessD On Behalf Of Bill Benson
Sent: Sunday, June 16, 2024 10:55 PM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Cc: Jim Dettman <jimdettman at verizon.net>
Subject: Re: [AccessD] Expert's Exchange; new program

ChatGPT is my new GoTO

On Fri, Jun 7, 2024 at 2:10 PM Jim Dettman via AccessD <
accessd at databaseadvisors.com> wrote:

>
>  EE has a different vibe to it though than other places.   Some like that
> and others don't.
>
>  For a while, they walked away from the community feel they had in the
> early 2000's, but now they are getting back to that.   It's just a shame
> they didn't do something like this 90-day trial a lot sooner.
>
>  I thought it was worth mentioning though.
>
> Jim.
>
> -----Original Message-----
> From: AccessD On Behalf Of Rocky Smolin
> Sent: Friday, June 7, 2024 1:21 PM
> To: Access Developers discussion and problem solving <
> accessd at databaseadvisors.com>
> Subject: Re: [AccessD] Expert's Exchange; new program
>
> Between AccessD, Stack Exchange and Google search, I never had the need for
> Experts Exchange. Google search is my GoTo. That's where Stack Exchange
> usually shows up. Although the links from a Google Search to a MS page work
> much of the time.
>
> r
>
> On Fri, Jun 7, 2024 at 8:25 AM Jim Dettman via AccessD <
> accessd at databaseadvisors.com> wrote:
>
> > All,
> >
> >
> >
> >    To anyone that's ever wondered about www.experts-exchange.com
> > <http://www.experts-exchange.com> , but didn't want to sign-up, they are
> > now
> > offering a 90-day trail with no CC required.   So if you've been curious,
> > check it out!  https://go.experts-exchange.com/
> >
> >
> >
> > Jim.
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com