Access Development Freelance

[Cy]

Hi all,

I wanted to start a thread that might help many of us. I worked for a
company for 12 years, until this past Christmas when they let me go.
Getting rid of the higher dollar guys, in favor of more profit, was the
reasoning. Oh well.

Anyhow. I built this companies network from the ground up. Then about
8 years ago, I developed a MS Access 2.0 database. This database, much
like others, was supposed to just tiny bits. Over the course of time,
we converted to 97, then to 2000, then this past summer to 2003. The
database now runs almost every aspect of the company, from contract
management to payroll (outsourced) to contact management to sales to
production measurement and budgeting tools, except the Accounting end,
yet it interfaces and pulls data out for custom report in Access.
Towards the end of my tenor, say the past 3 years, I had 2 guys doing
the hardware/break fix, while I spent most of the time developing. The
company is about $50 million in size, with about 80 users access this
database daily. The back end is SQL, front end Access.

Ok, enough of the history lesson. What I would like to figure out,
since I feel I have become pretty good at creating, modifying/making
databases, is any suggestions on how to get into consulting/freelance
Access work. I know, that I have read other threads, that state there
aren't a number of truly qualified Access developers out there. I've
tried finding free lance sites, but that seems like a fruitless effort.

Any help for a guy in Cincinnati who is trying to make it in life,
would be appreciated. Would be good to hear everyone else's take on
this.

Thanks for looking and commenting.

[Randy Harris]

"StopThisAdver tising" <StopThisAdvert ising@DataShit> wrote in message news:43******** *************** @text.nova.plan et.nl...
"PC Datasheet" <no****@nospam. spam> schreef in bericht news:ss******** *********@newsr ead2.news.atl.e arthlink.net...

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html (updated) Arno R

Arno, the web site looks good. It's just the facts. Leave the name calling
to datasheet (everyone that disagrees with him is a dimwit, loser, idiot,
goon or worse).

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.

[Marshall Barton]

Lyle Fairfield wrote:

After people read this previous post from Cy I'm sure he'll have
thousands of offers. You'll probably want to hire him to spruce up some
of your code!

Gee, I missed that thread. Well, a lot of us need a little
help now and then, but then I do have to wonder if moving
the DAO ref up the list is part of the "solution" in an
A97-A2K conversion.

--
Marsh

[Tim Marshall]

Rob Oldfield wrote:

I just find it a bit strange that there are these hordes of people reading
this, all of whom seem to adore Steve, and none of them have ever made the
effort to post a supportive message.

We've frightened them away, of course. They have an FK of 0.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

[Randy Harris]

"Marshall Barton" <ma*********@wo wway.com> wrote in message
news:fa******** *************** *********@4ax.c om...

Lyle Fairfield wrote:

After people read this previous post from Cy I'm sure he'll have
thousands of offers. You'll probably want to hire him to spruce up some
of your code!

Gee, I missed that thread. Well, a lot of us need a little
help now and then, but then I do have to wonder if moving
the DAO ref up the list is part of the "solution" in an
A97-A2K conversion.

--
Marsh

Marsh, if you're referring to the post by Wayne Gillespie, he did go on to
stress the importance of disambiguating all of the reference uses. I think
that is what most people would consider a "correct" solution - not relying
on reference priority.

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.

[Marshall Barton]

Randy Harris wrote:

"Marshall Barton" wrote

Lyle Fairfield wrote:

>After people read this previous post from Cy I'm sure he'll have
>thousands of offers. You'll probably want to hire him to spruce up some
>of your code!

Gee, I missed that thread. Well, a lot of us need a little
help now and then, but then I do have to wonder if moving
the DAO ref up the list is part of the "solution" in an
A97-A2K conversion.

Marsh, if you're referring to the post by Wayne Gillespie, he did go on to
stress the importance of disambiguating all of the reference uses. I think
that is what most people would consider a "correct" solution - not relying
on reference priority.

No, not Wayne's response. I was referring to the OP's
statement that he had moved ADO up the list. Of course
disambiguating is a good practice, but the odds of having an
A97 mdb that had a reference to ADO below DAO is pretty
slim, especially considering the question. Most often in
these conversions, it is best to just remove the unneeded
ADO reference instead of moving the DAO ref up the list. If
he had just let Access do the conversion, there wouldn't
even have been an ADO ref.

--
Marsh

[Randy Harris]

"Marshall Barton" <ma*********@wo wway.com> wrote in message
news:va******** *************** *********@4ax.c om...

Randy Harris wrote:

"Marshall Barton" wrote

Lyle Fairfield wrote:

>After people read this previous post from Cy I'm sure he'll have

Marsh, if you're referring to the post by Wayne Gillespie, he did go on tostress the importance of disambiguating all of the reference uses. I thinkthat is what most people would consider a "correct" solution - not relyingon reference priority.

No, not Wayne's response. I was referring to the OP's
statement that he had moved ADO up the list. Of course
disambiguating is a good practice, but the odds of having an
A97 mdb that had a reference to ADO below DAO is pretty
slim, especially considering the question. Most often in
these conversions, it is best to just remove the unneeded
ADO reference instead of moving the DAO ref up the list. If
he had just let Access do the conversion, there wouldn't
even have been an ADO ref.

--
Marsh

Oops. Sorry. I misconstrued. (trying to redeem myself by using a 25 cent
word) ;-)

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.

[Lyle Fairfield]

What about an A97 mdb with literals in place of predefined constants?
What are the odds of that?
I don't have AC97 and I can't remember. Can we get the value of a field
with (just) Recordset.Field in AC97?
I say the odds that the whole cover story is true are pretty slim, and
the odds that the code ever worked anywhere are slim; and how about the
odds that "99% of all my Access Dev. work has occurred in 2000", so I
know very little about 97"; In this thread he writes: "I built this
companies network from the ground up. Then about
8 years ago, I developed a MS Access 2.0 database. This database, much
like others, was supposed to just tiny bits. Over the course of time,
we converted to 97, then to 2000, then this past summer to 2003."

So what, in general am I concerned about? Treating this person's code
as if it's satisfactory, (it's a bucket of shit), and welcoming him to
the great association of Access Developers is a great way of
perpetuating the notion, in the Development world and elsewhere that
Access Development is a joke.

[PC Datasheet]

And so, Larry, let's cut through all your subterfuge and evasiveness crap
and I will ask you bluntly --

Isn't it true that a couple of years ago you emailed me and asked if I would
subcontract to you some of the Access database work I was doing for people
who saw my name in the newsgroups and sent me an email requesting fee-based
help from me?

Steve
PC Datasheet

"Larry Linson" <bo*****@localh ost.not> wrote in message
news:1lDCf.1429 $5G.18@trnddc08 ...

"PC Datasheet" <no****@nospam. spam> wrote

99% of the requests I get initially start with
"What would your fees be to ...."

If Steve's memory about "helping people" for a fee is as faulty as his
memory about my asking him to throw some work my way, his quotes are not
to be trusted.

And, to think, _he_ tries to label John Marshall, selected by Microsoft to
be an MVP because of his contributions to the user community, as a
"loser" -- it is to laugh.

Poor Steve. There was a time when he, mostly, followed the rules and just
put contact information in his SIG line, but need or greed or something
got the best of him. He apparently can't read the FAQ at
http://www.mvps.org/access/netiquette.htm, or can't understand it, or (my
guess) just won't abide by it.

Larry Linson

who cast an approving vote for the creation
of this newsgroup back in 1993... you can
find the record of that if you Google

[Saintor]

Apparently, he knows the difference of using e-mails for private business,
but not you.

In an effort of making him look bad (and there is nothing wrong to inquiry
about new potential business), you just confirm your jerk status.


"PC Datasheet" <no****@nospam. spam> wrote in message
news:by******** *********@newsr ead3.news.atl.e arthlink.net...

And so, Larry, let's cut through all your subterfuge and evasiveness crap
and I will ask you bluntly --

Isn't it true that a couple of years ago you emailed me and asked if I would subcontract to you some of the Access database work I was doing for people
who saw my name in the newsgroups and sent me an email requesting fee-based help from me?

Steve
PC Datasheet

"Larry Linson" <bo*****@localh ost.not> wrote in message
news:1lDCf.1429 $5G.18@trnddc08 ...

"PC Datasheet" <no****@nospam. spam> wrote

99% of the requests I get initially start with
"What would your fees be to ...."

If Steve's memory about "helping people" for a fee is as faulty as his
memory about my asking him to throw some work my way, his quotes are not
to be trusted.

And, to think, _he_ tries to label John Marshall, selected by Microsoft to be an MVP because of his contributions to the user community, as a
"loser" -- it is to laugh.

Poor Steve. There was a time when he, mostly, followed the rules and just put contact information in his SIG line, but need or greed or something
got the best of him. He apparently can't read the FAQ at
http://www.mvps.org/access/netiquette.htm, or can't understand it, or (my guess) just won't abide by it.

Larry Linson

who cast an approving vote for the creation
of this newsgroup back in 1993... you can
find the record of that if you Google

[Marshall Barton]

Lyle Fairfield wrote:

What about an A97 mdb with literals in place of predefined constants?
What are the odds of that?
I don't have AC97 and I can't remember. Can we get the value of a field
with (just) Recordset.Field in AC97?
I say the odds that the whole cover story is true are pretty slim, and
the odds that the code ever worked anywhere are slim; and how about the
odds that "99% of all my Access Dev. work has occurred in 2000", so I
know very little about 97"; In this thread he writes: "I built this
companies network from the ground up. Then about
8 years ago, I developed a MS Access 2.0 database. This database, much
like others, was supposed to just tiny bits. Over the course of time,
we converted to 97, then to 2000, then this past summer to 2003."

So what, in general am I concerned about? Treating this person's code
as if it's satisfactory, (it's a bucket of shit), and welcoming him to
the great association of Access Developers is a great way of
perpetuating the notion, in the Development world and elsewhere that
Access Development is a joke.

All valid points Lyle. I am guilty of not keeping track of
the context across multiple threads.

His view of his talents is his view, but, as you have
pointed out, it is his work (as demonstrated in the other
thread) that should be evaluated. Perhaps that's what
prompted the situation of this thread?

--
Marsh