I think if you reached the limits of ms-access, then you should consider
moving the data part to sql server, and continue to use ms-access as the
front end....
I don't recommend a workaround at all.
You don't mention how large, or how many records you have now. So, how many
records do you have now, and how large is your database now? (after a
compact and repair of course!).
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 = 2,147,483,648 Bytes
1 Character = 1 Byte
120 Characters = 120 Bytes
2 gig / 120 = 32 million records
Of course, if each customer name only takes up 60 characters...th en you can
store 64 million records in the file.
In real terms, I don't think anyone
would store close to the actual limits of the file size for ms-access.
So, it really all relative, and you not mentioned how many reords you have
now.
However, a table with 100,000 records in ms-access is rather small...
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com