Access hangs after table grows to 12000 records

[ral amo]

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 ***

[Gaspare]

"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

[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