Maximum size???

[Rogdool]

Does anyone know if there is a maximum workable size to a access 2000 database? Mine is 2.1 Gigs and I'm running into problems adding more data, I'm getting "INVALID ARGUMENT" once I get to a cetrain point adding picyures as objects in one of my tables.

Any Ideas?

 

[bradcccs]

Safe to say "You've reached it!"

Search this forum. Many posts on this topic.

Brad.

**edit**

Sorry: Many posts on both topics:
1) Max size
2) Storing pics in a database.

****

 

[pitou]

max size for a database.

hello Rogdool !


happy to read your question. On this site, I already asked the same question, that i think is very important.

Some kind people (thanks Doc_man) answered my question.

In the meantime, i have been gathering some informations that I hope will be useful and convenient to other readers.

First, your database is too big !.
I also read on another site someone who had a 6 million records table (oulalah!)

The solution should be to split it into other smaller Access databases or to make it migrate to SQL/server or Oracle.( I acknowledge that i do not how to do it).

As for me, I will never surpass 80 or 100 M.O. for one database . If this database is used by several people at the same time, not over 50 M.O or 60.
Those digits seem quite low , but I think it is a way to have proper and safe applications and not to be surprised in the aftermath...
we could have several databases in BE an another in FE with linked tables to overcome these limitations

As for the number of records in one table, I will not exceed 150000 or 200000, which is already not so bad (I do not know for pictures), due to speed of the SQL queries .

the design of the database and optimization of the code and the queries are very important, also to compact it from time to time.

Well, here is my short reply. Hope it will help you

Pitou

 

[Rogdool]

Re: max size for a database.

hello Rogdool !


happy to read your question. On this site, I already asked the same question, that i think is very important.

Some kind people (thanks Doc_man) answered my question.

In the meantime, i have been gathering some informations that I hope will be useful and convenient to other readers.

First, your database is too big !.
I also read on another site someone who had a 6 million records table (oulalah!)

The solution should be to split it into other smaller Access databases or to make it migrate to SQL/server or Oracle.( I acknowledge that i do not how to do it).

As for me, I will never surpass 80 or 100 M.O. for one database . If this database is used by several people at the same time, not over 50 M.O or 60.
Those digits seem quite low , but I think it is a way to have proper and safe applications and not to be surprised in the aftermath...
we could have several databases in BE an another in FE with linked tables to overcome these limitations

As for the number of records in one table, I will not exceed 150000 or 200000, which is already not so bad (I do not know for pictures), due to speed of the SQL queries .

the design of the database and optimization of the code and the queries are very important, also to compact it from time to time.

Well, here is my short reply. Hope it will help you

Pitou

 

[Rogdool]

THANKS

Thanks all,

I'm splitting up the database, which will be much more manageable. Not to mention, the backup operation will be a breeze, no more multi CD burns.


Rog

 

[The_Doc_Man]

Although it will make lots of extra problems in backups, you should not include pictures in the database. Instead, include links. Maybe keep the picture files in the same directory as the database, maybe in a subdirectory thereof.

You will not believe just how expensive (in terms of the Access internal address space) a picture can be. I cannot say for sure just how much because you didn't say whether your pictures were .jpg or .bmp or .wmf, which makes somewhat of a difference.

In the case of the .jpg stuff I take with my digital camera, the files are 45K to 130K. The link for one such picture wouldn't amount to 1/4 K for the worst file reference on my disk. How many 1/4 K increments can you fit in 45K? (That was a rhetorical question.)