The size limit of access 2002 is 2 gigs.
So, if you take a average name in a mailing list, add a few extra
fields...your record size might be about 120 characters on average in size.
So, the number of records you can store is:
2 gig / 120 = 32 million records
So, the limit is NOT the number of records..but "how many" records you can
fit into 2 gig.
Of course, if each customer name only takes up 60 characters...then you can
store 64 million records in the file.
If I need to convert to an SQL Server type, do I need to
purchase additonal software or just use access 2002.
You can continue to use ms-access, and then move your data to sql server.
Ms-access works very good with sql server.
How many records do you plan to store? In real terms, I don't think anyone
would store close to the actual limits of the file size for ms-access when
not using sql server. I think in real terms....a few hundred thousands
records is certainly fine with ms-access. Issues of using sql server will
depend on things like the number of users you plan to have, type access
(remote, or over a wan), and issues like security (who can use the data).
But, a file with 100,000 records in ms-access is not large at all....
