MS Access - maximum records
09 September 2002, 07:21 AM
#1
Scooby Regular
Thread Starter
Join Date: Oct 2000
Posts: 184
Likes: 0
Received 0 Likes
on
0 Posts
In MS Access 2000, is there a imit as to the maximum number of records ?
eg we push through circa 20,000 transactions per week.
For a 50 week year, thats 1,000,000 records.
Will Access cope ??
eg we push through circa 20,000 transactions per week.
For a 50 week year, thats 1,000,000 records.
Will Access cope ??
09 September 2002, 09:41 AM
#2
Scooby Regular
Join Date: Sep 1999
Location: Bedfordshire
Posts: 4,037
Likes: 0
Received 0 Likes
on
0 Posts
airhead,
it wont be a # of records limitation, it will be the max. file size of 2gb that will be your limit. For your requirements I dont think access is beefy enough, with that many records being added each week I think you will suffer performance problems pretty quickly. You might want to look at MSDE (microsoft data engine), do a search for it, which is basically a SQL Server 2000 desktop database engine which you can administer using microsoft management console.
Cheers
Gary
it wont be a # of records limitation, it will be the max. file size of 2gb that will be your limit. For your requirements I dont think access is beefy enough, with that many records being added each week I think you will suffer performance problems pretty quickly. You might want to look at MSDE (microsoft data engine), do a search for it, which is basically a SQL Server 2000 desktop database engine which you can administer using microsoft management console.
Cheers
Gary
09 September 2002, 12:39 PM
#3
Scooby Regular
Join Date: Jun 2000
Posts: 13,735
Likes: 0
Received 0 Likes
on
0 Posts
We're still using Access for something that was a quick fix but has now ended up as a core system...
It's sufficient for a LOT of things. But if you can use SQL server back end, and maybe use access as your front end for reports, forms etc then you may save yourself hassle in the distant future?
It's sufficient for a LOT of things. But if you can use SQL server back end, and maybe use access as your front end for reports, forms etc then you may save yourself hassle in the distant future?
09 September 2002, 02:27 PM
#5
Scooby Regular
Join Date: Sep 1999
Location: Bedfordshire
Posts: 4,037
Likes: 0
Received 0 Likes
on
0 Posts
airhead,
I wouldn't advise using Access for the front-end or the back-end its just too lightweight for your needs. If you did the front end in something like (cough, spit, splutter - dare I even say it!) Visual Basic you can just connect using ADO to talk to Access then migrate to MSDE and you wont even need to change any client side SQL or connection strings.
Gary
I wouldn't advise using Access for the front-end or the back-end its just too lightweight for your needs. If you did the front end in something like (cough, spit, splutter - dare I even say it!) Visual Basic you can just connect using ADO to talk to Access then migrate to MSDE and you wont even need to change any client side SQL or connection strings.
Gary
09 September 2002, 08:00 PM
#6
Scooby Regular
Join Date: Jan 2000
Location: Peterborough
Posts: 231
Likes: 0
Received 0 Likes
on
0 Posts
If you want to stick with Access there are lots you can do to avoid the limits and speed it up.
The max file size is 2Gb under windows 98 and 4Gb under NT and later.
You can link to as many external 2Gb files as you like, so you can easily change the structure to work within this.
Lots of compacting and repairing.
Play with the indexes you use, it can have major implications on speed.
Good luck.
The max file size is 2Gb under windows 98 and 4Gb under NT and later.
You can link to as many external 2Gb files as you like, so you can easily change the structure to work within this.
Lots of compacting and repairing.
Play with the indexes you use, it can have major implications on speed.
Good luck.
10 September 2002, 07:50 AM
#7
Scooby Regular
Thread Starter
Join Date: Oct 2000
Posts: 184
Likes: 0
Received 0 Likes
on
0 Posts
Number of users will be 1 or 2 max.
Seems that it uses 2.5mb per week, but I may be able to trim that down.
I guess 2.5mb pw will be within the max limit.
Be an interesting exercise as it gets larger.
MSDE sounds interesting, something I will explore. Ta.
Seems that it uses 2.5mb per week, but I may be able to trim that down.
I guess 2.5mb pw will be within the max limit.
Be an interesting exercise as it gets larger.
MSDE sounds interesting, something I will explore. Ta.
Thread
Thread Starter
Forum
Replies
Last Post
Pro-Line Motorsport
Car Parts For Sale
2
29 September 2015 07:36 PM