MS Access questions - Scalability / indexing / transactions

Posted by oo on Stack Overflow See other posts from Stack Overflow or by oo
Published on 2008-10-07T18:34:28Z Indexed on 2010/05/06 14:58 UTC
Read the original article Hit count: 237

Filed under:
|

A few questions on MS Access databases -

Size: Are there limits to the size of an access database? The reason i ask is that we have an access database that has a few simple tables. The size of the db is about 1GB. When I do a query on it, i see it taking over 10 minutes to run.

With proper indexing, should MS Access be able to handle this or are there fundamental limitations to the technology.

This is MS Access XP.

Also, does MS Access support db transactions, commit and rollback?

© Stack Overflow or respective owner

Related posts about ms-access

Related posts about rdbms