Strictly speaking, Steve, the ADP or ADE is not stored by SQL Server -
tables, views and stored procedures are stored by SQL Server, usually in a
file with an MDF extension, while forms reports and code live outside of SQL
Server in the ADP or ADE. If you're using MSDE then the limit is, as John
says elsewhere in this thread, 2GB. If you're using full SQL Server the
maximum *file* size is 32 TB (that's TB, Terabytes) but a database can use
multiple files, the maximum *database* size is 1,048,516 TB. (These figures
are from SQL Server Books Online). The Access 2003 help file doesn't appear
to state what the maximum size of the ADP or ADE itself is, but as the data
is not stored within the ADP or ADE, that is unlikely to be an issue.
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.