By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,574 Members | 2,966 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,574 IT Pros & Developers. It's quick & easy.

Access hangs after table grows to 12000 records

P: n/a
We've a project for which we are using MS Access as the back end and VB
as front end. there are three terminals fromn whichusers access the
system. The table has 17 rows. When the number of records reach 12000
the system hangs.

Does anybody know what's the reason for this?Is table size or database
size is a limitation of MS ACeess. Pls help. It's very urgent.

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

"ral amo" <la*****@yahoo.com> ha scritto nel messaggio
news:dN***************@news.uswest.net...
We've a project for which we are using MS Access as the back end and VB
as front end. there are three terminals fromn whichusers access the
system. The table has 17 rows. When the number of records reach 12000
the system hangs.

Does anybody know what's the reason for this?Is table size or database
size is a limitation of MS ACeess. Pls help. It's very urgent.

*** Sent via Developersdex http://www.developersdex.com ***


Hi,
for Access 97 the maximun size of database is 1GB, for Access > 97 is 2GB

Gaspare
Nov 13 '05 #2

P: n/a
Br
ral amo wrote:
We've a project for which we are using MS Access as the back end and
VB as front end. there are three terminals fromn whichusers access the
system. The table has 17 rows.
Ya mean columns? :)
When the number of records reach 12000
the system hangs.

Does anybody know what's the reason for this?Is table size or database
size is a limitation of MS ACeess. Pls help. It's very urgent.


12,000 records shouldn't be a problem at all, especially with only 7
columns. It's more likely something to do with your VB front end.

Br@dley
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.