record limit and size

[kenlo]

1. Excel has a limit of the number of rows. Is there a
limit on Access how many records can be saved in one file?

2. The file size gets bigger everyday even after
compacting. Eventually the flash memory cannot carry
it. What is the best solution to manage the size like
breaking it down into two or so?

 

[Tony Toews]

1. Excel has a limit of the number of rows. Is there a
limit on Access how many records can be saved in one file?

Whatever fits in 1 Gb for A97/Jet 3.5 MDBs and 2 Gb for A2000 or
newer/Jet 4.0 MDBs.

2. The file size gets bigger everyday even after
compacting. Eventually the flash memory cannot carry
it. What is the best solution to manage the size like
breaking it down into two or so?

What flash memory? Presumably data is accumulating in the MDB so it
getting larger would be expected. How much larger per day is it
getting?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm