Discussion Locked

Could Access 2003 support 9k trans. a month?

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Could MS Access 2003 be able to support an application to handle about 9,000 transactions per month and about 50 users? I'm planning to design it using Data Access Pages.

7 replies

by kelvin lin

If all the 50 users are using the Access concurrently,performance of the MS Access will be effected.

Regarding the transaction values, it will be depending on how many records are involved in transaction.

by crosu

I?m using for over 5 years a MSAccess application synchronized on three sites (2 in Canada and one in U.S.). The data exchanged is really high (over 50 tables many of them reaching 100 fields, 50 static queries and a lot more hard-coded, 30 forms, and 53 VBA modules). For a real programmer is hard to imagine something that cannot be done in VBA & API when comes to MSAccess. With an average of 15-20 simultaneously users the speed is acceptable. However, depends a lot on the traffic on the LAN, disrupted wireless connections for laptops, and less powerful workstations when working with a 5 MB front-end and 60 MB back-end.

by tony hopkinson

course if you are hoping for the number of transactions and or number of users to grow, then you might as well get rid of it now.
If you are in an ms environment, MSSQLDE might be a better a choice. MySQL or the more feature rich PostGreSQL are free solutions for this sort of thing as well.
Personally I wouldn't use access for anything more than managing my CD collection.

by kelvin lin

For MSSQL, you can refer to Microsoft website (but it's not free, and cost a lot for the license), MySQl and PostgreSQL are open source and free for commercial usages.

by tony hopkinson

but a small amount of data. Suitable for access. Generally I operate with databases in the 60 GB range. I'd also suggest you could get some significant performance improvements with a switch to a DBMS solution for access's file based one. Whether the money is there to do it is another question.

This discussion is closed to new replies.