Record limit and file 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?


Kenneth

 

[mackie]

i tried converting a dbase file into an access table with
more than one million records....

it took a while though to process even a simple query...

hope this gives you idea

 

[Kevin3NF]

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?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

 

[Tom Wickerath]

Hi Kenneth,

Here are some additional things to check out regarding .mdb file bloat:
http://tinyurl.com/2dmpw

Tom
_________________________________


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?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

_________________________________



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

 

[Tom Wickerath]

Hmmm......after posting this message, I attempted to verify the saved link. It seems to be
opening up a different search (Word Mail Merge) on my PC. Here is an alternate link, although
you may have to deal with word wrap issues to put this longer link back together again:

http://support.microsoft.com/search...L&maxResults=25&Titles=false&numDays=&InCC=on


Tom
________________________________


Hi Kenneth,

Here are some additional things to check out regarding .mdb file bloat:
http://tinyurl.com/2dmpw

Tom
_________________________________


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?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

_________________________________



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

 

[kenlo]

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

 

[john sanchez]

Hi Kenneth,

Here are some additional things to check out regarding .mdb file bloat:
http://tinyurl.com/2dmpw

Tom
_________________________________


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?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

_________________________________



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