Hey jtwestmo!
From your description of requirements, I would say you are save to stick to Access and avoid the higher priced "spread".
Some of the limits of access are:
2GB MDB size limit
2K record length limit (not including memo's that are stored separately)
It doesn't some like you would hit either of these with the specs you stated.
Proper db design and normalization should keep you well away from the 2K record limit.
regards
Jack
Main Topics
Browse All Topics





by: Arthur_WoodPosted on 2003-12-24 at 08:39:12ID: 9997178
Access should be just fine. SQL Server would be VERY expensive.
Access 2000 is limited to a MAXIMUM MDB file size of 2 Gigabytes, but the job parameters you describe should not reach anything close to that limit for MANY years.
AW