Access Filesize Limit

Hi.

I've been working on a database system which is based on an Access'97 Database.
The problem I've come across is that an Access'97 database can only be 1GB large. When looking in to the Access'2000 I noticed that it can store 2GB of information. But the problem is, I WANT MORE SPACE!!! ;)
Is there anyway to work around this problem??
And why the hell did MS use this kind of limit? I could have understood if the limit was for example 1.000.000 entries, or something like that, but a limit for the filesize of the database..

Thanks in advance..

[valkyrie]

Hi,
There is one way, upgrade to SQL Server, but that requires NT, etc. That is one practical workaround if you know that your database is going to grow quite large.

____________________________________
The VB Bugs in my Life...

[Chris Eastwood]

Another helpful hint is to compress the Access Database on a regular basis - this tidies up all those delete items that leave 'gaps' in a database and help keeps the size down.

Chris Eastwood

CodeGuru - the website for developers
http://codeguru.developer.com/vb

Although the limit is 1 or 2 GB, I do not think that Access db with the size more than 400-500 MB can work well. Except the case when it was designed ugly. On 1 of my previous jobs I met Access db with the size more than 300 MB. I made it 300 smaller times. How? It was very easy. Designer of that db knew nothing about relationships and one of his tables contained a couple of thousands records with signatures of salesmen (there were 6 salesmen, 6 signatures and each of them was bmp with 100 KB in size). And there were some similar mistakes like repeting columns (violation of First Normal Form), redundant data, storing values for different entities in one table and so on. Maybe you have something to redesign to make db smaller. I don't think, that small company can have so big db, and bigger companies do not use Access as a primary db. So the limit of 2 gigs is more than enough for everything what can be done with Access.
Vlad