Please Help With This Mis(?)Information

  • Thread starter Thread starter S Jackson
  • Start date Start date
S

S Jackson

Someone is saying that when access has record size limitations and when he
had up to 1 gig of data, Access would not work properly. Is this true?

Also, others are saying that to go to SQL it would cost about $2K or $3K.
True?

TIA
Shelly
 
Someone is saying that when access has record size limitations and when he
had up to 1 gig of data, Access would not work properly. Is this true?

Also, others are saying that to go to SQL it would cost about $2K or $3K.
True?

TIA
Shelly
Click to expand...

The maximum size for Access 97 is 1 Gb, including data and all
objects, i.e. forms, reports, etc.

The maximum size for Access 2000 and newer is 2 Gb.

This information, and more, is available in Access Help.
Specification + Access specification + Access Database
 
Hi Shelly,

Yes, there are limits. I'm actually kind of suprised
that MS upped the cap to 2Gb on Access 2K, since you'll
start seeing pretty major performance issues in an 800 MB
Access .mdb and you'll be ready to beat yourself (and the
computer) with a hammer while waiting for queries to run
when that baby tops 1 Gb.

$2k to $3k to go to SQL Server would be well....cheap.
Not sure what the software is going for right now (~$2k
last time I looked, but that's been a while), but then
getting the hardware, learning to write SQL, learning the
ins and outs of database administration (hint: this is a
nice paying, full-time job for a lot of folks), modifying
your Access .MDB to work with SQL Server (I've made a
nice living off of doing these conversions), etc. Well,
yeah, $2k to $3k would be a bargain.

It can be a bit of a shocker.

cheers,

Fred D
 
Yes, there are limits. I'm actually kind of suprised
that MS upped the cap to 2Gb on Access 2K, since you'll
start seeing pretty major performance issues in an 800 MB
Access .mdb and you'll be ready to beat yourself (and the
computer) with a hammer while waiting for queries to run
when that baby tops 1 Gb.
Click to expand...

I wonder how long it would take for my db to get to 1gig? We've beem using
it for about 4 yrs and the backend is about 1.4 mbs, with maybe only about
260 records in it - - - > just wondering out loud.
$2k to $3k to go to SQL Server would be well....cheap.
Not sure what the software is going for right now (~$2k
last time I looked, but that's been a while),
but then getting the hardware, learning to write SQL, learning the
ins and outs of database administration (hint: this is a
nice paying, full-time job for a lot of folks),
Click to expand...

Yep! Here I sit a lowly underpaid legal assitant - me thinks I'm being had!
I work for a state agency, so therein lies my problem, however . . . .
Oh - and just to set the record straight (because I really hate to tell
anyone I work for a state agency b/c of the whole stereo-type thing), but a
state paid job is one of the best paying jobs in in my little corner of the
world and that sure isn't saying much for the real job market is it?
modifying your Access .MDB to work with SQL Server (I've made a
nice living off of doing these conversions), etc. Well,
yeah, $2k to $3k would be a bargain.

It can be a bit of a shocker.
Click to expand...

Yep! I can see that this is way outta my league!
cheers, (Yes, I think a cocktail or two would definitely be in order!)
Fred D
Click to expand...

Thanks for your reply!
Shelly
 
"S Jackson" wrote
I wonder how long it would take for my db
to get to 1gig? We've beem using it for about
4 yrs and the backend is about 1.4 mbs, with
maybe only about 260 records in it - - - > just
wondering out loud.
Click to expand...

In the same vein... a long time... actually a long, long time. Even longer
if you haven't been regularly Compacting your database. A GB is 1000 MB.
Yep! Here I sit a lowly underpaid legal
assitant - me thinks I'm being had!
Click to expand...

Chances are slim to none that you'll have a personal database that requires
SQL Server. It takes a lot of data entry keyboarding to grow a database to
2GB! Your fingers would be worn down to the first joint or so.

There is a free SQL Server Desktop Edition that comes with Access, also
known as MSDE, but it also has a 2GB limit. There's a new beta of the
"Yukon" SQL Server Express that is even better than MSDE, but it isn't a
full-fledged SQL Server, either.

Larry Linson
Microsoft Access MVP
 
Back
Top