|
|
|
|
wanttorun100
Member
|
|
|
Joined: 14 Feb 2005
Posts: 4946
Location: Just to the right of Atilla the Hun!
|
| Back to top
|
|
 Posted: 05/31/05 - 07:45 Post subject: MS Access sucketh!
And this place is in LOVE with the POS database
If I wasn't getting paid an insane hourly rate I'd ...
Ok jokes over somebody please gimme back DB2
|
|
|
|
|
Noley
AZhat
|
|
|
Joined: 16 Aug 2003
Posts: 10494
|
| Back to top
|
|
Posted: 05/31/05 - 07:47 Post subject:
I read this wrong... 
Sorry for this for ya!
Last edited by Noley on 05/31/05 - 07:49; edited 2 times in total
|
|
|
|
|
MastrBrewr
Saccharomyces cerevisiae
|
|
|
Joined: 24 Sep 2003
Posts: 6974
Location: outside
|
| Back to top
|
|
Posted: 05/31/05 - 07:48 Post subject:
What are ya trying to do with it?
There's not much I haven't managed to pull of with Access. I almost never gives me problems.
|
|
|
|
|
Maddies Wench
Flailing Homosapiens
|
|
|
Joined: 12 Jun 2003
Posts: 6103
Location: Seeking out the poorer quarters where the ragged people go.
|
| Back to top
|
|
Posted: 05/31/05 - 07:51 Post subject:
I heart Access. Most all of the duplication of work that was done previously in this position I have automated with Access.
|
|
|
|
|
wanttorun100
Member
|
|
|
Joined: 14 Feb 2005
Posts: 4946
Location: Just to the right of Atilla the Hun!
|
| Back to top
|
|
Posted: 05/31/05 - 07:55 Post subject:
| MastrBrewr wrote: | What are ya trying to do with it?
There's not much I haven't managed to pull of with Access. I almost never gives me problems. |
heavy duty database stuff - partial matching on names and addresses.
mostly what we're doing it just too big for what Access can do - always up at the 2 gig limit.
I miss being able to do a full outer join, a count( distinct id )
and it's dawg slow.
indexes don't seem to help much and we don't have the space.
The one thing I cann't complain about is my hourly rate - well unless I look at what my pimp gets compared to what I get.
|
|
|
|
|
wanttorun100
Member
|
|
|
Joined: 14 Feb 2005
Posts: 4946
Location: Just to the right of Atilla the Hun!
|
| Back to top
|
|
Posted: 05/31/05 - 07:57 Post subject:
| Maddie's Wench wrote: | | I heart Access. Most all of the duplication of work that was done previously in this position I have automated with Access. |
Access is good for that sorta stuff, light duty office stuff but as a serious database tool it sucks eggs!
|
|
|
|
|
MastrBrewr
Saccharomyces cerevisiae
|
|
|
Joined: 24 Sep 2003
Posts: 6974
Location: outside
|
| Back to top
|
|
Posted: 05/31/05 - 07:59 Post subject:
| wanttorun100 wrote: |
heavy duty database stuff - partial matching on names and addresses.
mostly what we're doing it just too big for what Access can do - always up at the 2 gig limit.
I miss being able to do a full outer join, a count( distinct id )
and it's dawg slow.
indexes don't seem to help much and we don't have the space.
The one thing I cann't complain about is my hourly rate - well unless I look at what my pimp gets compared to what I get. |
There ya go. Way too much stuff. Most of my files are only around 10-30 MB size, and only under 200k records. Any bigger and we use Access as a front-end to the MS-SQL server.
|
|
|
|
