| | |
|
|
|
Record limit and file size |
|---|
| message from kenlo on 27 May 2004 |
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?
Kenneth
|
| Kevin3NF replied to kenlo on 27 May 2004 |
1. No, until you reach the max file size
2. WinZip compresses most of my Access dbs by about 80%. Why are you moving
it around that much? Have you split it into Front-end and Back-end?
|
| Tom Wickerath replied to Kevin3NF on 27 May 2004 |
Hi Kenneth,
http://tinyurl.com/2dmpw
Tom
_________________________________
"Kevin3NF" <KHill@NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:OtOdL1CREHA.2408@tk2msftngp13.phx.gbl...
1. No, until you reach the max file size
2. WinZip compresses most of my Access dbs by about 80%. Why are you moving
it around that much? Have you split it into Front-end and Back-end?
|
| kenlo replied to kenlo on 28 May 2004 |
Many thanks to all of your advice. I basically save the
file from the office PC in a flash memory to work on the
home PC.
Kenneth
file?
|
| mackie replied to kenlo on 27 May 2004 |
it took a while though to process even a simple query...
hope this gives you idea
|
|
Archived message: Record limit and file size (Microsoft Access Forms)
