How large should I let database get ?

[Fred Smith]

Morning all,

I've got an Access database running on a network at work. The current file
size with 3 months of data is 251mb. How large should I let the database get
before I start achieving previous months ?

Thanks

Stu

[Baz]

With a database growing at that rate I would archive unwanted data as soon
as it becomes redundant. In any case there is an absolute maximum of 2Gb on
your database size, which you will hit sooner rather then later at your
current rate of increase.

"Fred Smith" <st*********@btopenworld.comwrote in message
news:Db******************************@bt.com...

Morning all,

I've got an Access database running on a network at work. The current file
size with 3 months of data is 251mb. How large should I let the database

get

before I start achieving previous months ?

Thanks

Stu

[Keith Wilby]

"Fred Smith" <xx*@btopenworld.comwrote in message
news:Db******************************@bt.com...

I'd munge my e-mail address if I were you Fred, you don't want to be
inundated with spam do you?

Keith.

[paii, Ron]

How big is it after a compact and repair? I do a compact and repair on all
BE files once a week using a function in a MDB executed by Task manager.

Is the 251MB new data or has it been imported from other systems? Is the
growth from text data or are you storing images and other non text
information?

As others have said, there is a 2GB limit. If you are truly creating 84MB of
new data every month you should look at changing your BE to SQL Server.

"Fred Smith" <st*********@btopenworld.comwrote in message
news:Db******************************@bt.com...

Morning all,

I've got an Access database running on a network at work. The current file
size with 3 months of data is 251mb. How large should I let the database

get

before I start achieving previous months ?

Thanks

Stu

[Mark]

Keith,
how do you 'munge' my email address?

Rgds,

Mark

"Keith Wilby" <he**@there.comwrote in message
news:46**********@glkas0286.greenlnk.net...

"Fred Smith" <xx*@btopenworld.comwrote in message
news:Db******************************@bt.com...

I'd munge my e-mail address if I were you Fred, you don't want to be
inundated with spam do you?

Keith.

[JimH]

--

how do you 'munge' my email address?

Outlook Express:
Tools, Accounts, Double click the one in news, change email address to
whatever.
I guess??

[Fred Smith]

Thanks for the advice. Thats taken it down to 54Mb
Wonder how the hell it ended up so big ?
"paii, Ron" <pa**@packairinc.comwrote in message
news:Sp******************************@athenet.net. ..

How big is it after a compact and repair? I do a compact and repair on all
BE files once a week using a function in a MDB executed by Task manager.

Is the 251MB new data or has it been imported from other systems? Is the
growth from text data or are you storing images and other non text
information?

As others have said, there is a 2GB limit. If you are truly creating 84MB
of
new data every month you should look at changing your BE to SQL Server.

"Fred Smith" <st*********@btopenworld.comwrote in message
news:Db******************************@bt.com...

>Morning all,

I've got an Access database running on a network at work. The current
file
size with 3 months of data is 251mb. How large should I let the database

get

>before I start achieving previous months ?

Thanks

Stu

[paii, Ron]

Access does not release the disk space when records are deleted until you
compact. Doing Compact and Repair on a regular schedule will keep the file
clean and may reduce the number of DB corruptions.

"Fred Smith" <hi****@nospam.co.ukwrote in message
news:45*********************@bt.com...

>
Thanks for the advice. Thats taken it down to 54Mb
Wonder how the hell it ended up so big ?
"paii, Ron" <pa**@packairinc.comwrote in message
news:Sp******************************@athenet.net. ..

How big is it after a compact and repair? I do a compact and repair on

all

BE files once a week using a function in a MDB executed by Task manager.

Is the 251MB new data or has it been imported from other systems? Is the
growth from text data or are you storing images and other non text
information?

As others have said, there is a 2GB limit. If you are truly creating

84MB

of
new data every month you should look at changing your BE to SQL Server.

"Fred Smith" <st*********@btopenworld.comwrote in message
news:Db******************************@bt.com...

Morning all,

I've got an Access database running on a network at work. The current
file
size with 3 months of data is 251mb. How large should I let the

database

get

before I start achieving previous months ?

Thanks

Stu

[Tony Toews [MVP]]

"Fred Smith" <hi****@nospam.co.ukwrote:

>Thanks for the advice. Thats taken it down to 54Mb
Wonder how the hell it ended up so big ?

Typical every day wear and tear. <smile>

Compacting weekly is about all that is required. Even monthly. I wouldn't bother
doing it every day as the first time someone goes to insert or update records Jet
will expand the MDB by 5% or 10% anyhow.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/