Access 2000 size limits.

[Carl]

Had to do a little house cleaning, as my computer has "only" a 5 GB hard drive.

That was O.K., I put my old race files on a couple of cd's then deleted them, HOPEFULLY the technology works when I need it. (If not, I am my own computer crash hehe.)

Question though. At present time, my access files (all HTR related) are taking up 2.15 GB of space. I have done "compact & repair" several times on each (there are about 30 db's in total). I remember reading somewhere that a Access program can only hold 2 GB's of information. So am I nearing crash city here? Everything seems to be working hunky booie, but you never know......

later,
Carl

[ERNIE]

Carl:
About Access limits I don't know, but I'm thinking that it would be good to remind you that when bringing "old racefiles"out of storage into "any" htr program that race file will be stroed in "htrdata" again AND,AND,AND WILL OVERWRITE ANY FILE WITH THE SAME DATE. example:in the future, say july 2002 you decide to bring back races from puffen-bluff downs from july2001 because the year is not part of the file name it will overwrite (without asking any questions) any file of the same track-n-date ......in the htrdata directory.....
Solution is to backup your htrdata dir. before reconstructing ......unzipping any old files.
this is the voice of experance speaking.............another way to back door this problem is to rename your "real"htrdata dir" something else while your doing your retriving/reconstructing

Another small problem that I have/had was that my computer(Gateway Laptop) will only let me have somewhere between 2500 and 3k races in my htr dir it will just quit displaying them,trouble is it keeps all the files that are there(older) and ignores any new stuff I try to look at.

This ruined a day at the races once.........I wanted to create a model, it would unzip and display the race files but not the result files.........the reason it ruined the day was because I panicked,thinking that my data or program was "chop suey" and if this data was bad it stood to reason that the data I was betting with was bad also..........not so ,when calm reasoning returned and I deleted some races in the htr dir everything was ok.
Hope this is helpful: ERNIE

[hurrikane]

Carl, is would seem unusual that a relational database would only hold 2g of data. I'm am much more familiar with oracle but access should hold much more that that. Likely Mike or Donnie would know the answer. I can ask around W**k and see if anyone has heard anything.

If I were you I would be more concerned with disk space. 40% of you're drive is eaten up by access HTR data. that can't be good. Hard drives are very cheap these days (even in Cananda) and as long as you have the expansion room (you could slave it off your current ir you have room in your box) you should get one.
Hmmm...come to think of it..so should I.

Ernie...you bring back some bad memories of 'my data is junk' nightmares. :D

[MikeDee]

got this from Access Help look under size limiations - all kinds of info on sizes. Since I use 97 your verson of 2000 could be different maybe 2 gig


Attribute MaximumDatabase (.mdb) file size 1 gigabyte.

[Rick]

In Access 2002 the DB & Table size limit is listed as: 2 gigabyte minus the space needed for the system objects

As I recall under Access 2000 it was DB 2 gig and table 1 gig

[Carl]

Thanks guys.

I don't have any table bigger than maybe .3 GB, just the total for all access db's together is over 2 GB.

Maybe I read that the table size is limited to 2 GB, if that is the case then I am not even close to a problem yet.

And thanks Ernie, I may well have forgotten about that. And you're right Hurrikane, it is just that I keep thinking I'll get a new beast but this one and I keep chugging along.

later,
Carl