1, if it's big enough (huge OLE or Memo field). Almost 400 million if they
are small enough (Long Integer as PK and a bit field). The usable size of an
Access database depends upon the database design, the number of active users
and the type of data being stored.
Typically a comfortable size on a well-designed database is under 40 to 50
users and 5 or 6 hundred MB's of data.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads: http://www.datastrat.com http://www.mvps.org/access
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
