MS Access questions - Scalability / indexing / transactions
- by oo
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?