Re: Access Filesize Limit
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...
Re: Access Filesize Limit
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
Re: Access Filesize Limit
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