Size limitation

D

Darren

I would like to find out what size limitation an Access database has (Number
of records?)
 
D

Douglas J Steele

There is no limitation in terms on number of records. The only data-related
size limitations are that an Access MDB cannot exceed 2 Gb (1 Gb in Access
97 and earlier), and that a single record cannot exceed 2,000 characters
(not counting Memo fields). However, that first limitation isn't all that
severe, as you can link your application to other back-end databases.
 
Top