Access 97 Size and performance.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kevin Nguyen - 31 Dec 2003 16:00 GMT

I have an access database that is about 46MB. I have it
stored on a server and for some reason, it has been
running very slowly since it reach the size of 40mb. Is
there some documentation that states what is an average
size for a database?

Reply to this Message

Kevin3NF - 31 Dec 2003 16:06 GMT

All depends on the database. Have you compacted it?

Signature

Kevin3NF

Sick of all that junk filling up your mailbox?
http://spamarrest.com/affl?2967001

> I have an access database that is about 46MB. I have it
> stored on a server and for some reason, it has been
> running very slowly since it reach the size of 40mb. Is
> there some documentation that states what is an average
> size for a database?

Reply to this Message

kevin Nguyen - 31 Dec 2003 19:18 GMT

it has been compacted. What is a typcal size for a
database?

>-----Original Message-----
>All depends on the database. Have you compacted it?
[quoted text clipped - 6 lines]
>
>.

Reply to this Message

Douglas J. Steele - 31 Dec 2003 19:35 GMT

46 MB is still quite small for an Access database. Once you get into the
hundreds of MB, then you can call it large.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

> it has been compacted. What is a typcal size for a
> database?
[quoted text clipped - 10 lines]
> >
> >.

Reply to this Message

Kevin3NF - 31 Dec 2003 20:03 GMT

I have a client in Maryland that I have done 6 databases for, the largest is
20MB.

I have a different client in Dallas....their database is over 200MB.

46mb is not that big, unless you have a very limited number of objects and
records. But you have told us nothing about the database to help resolve
the performance issues.

Signature

Kevin3NF

Sick of all that junk filling up your mailbox?
http://spamarrest.com/affl?2967001

> it has been compacted. What is a typcal size for a
> database?
[quoted text clipped - 10 lines]
> >
> >.

Reply to this Message