<p>A few questions on MS Access databases -</p>

<p>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.  </p>

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

<p>This is MS Access XP. </p>

<p>Also, does MS Access support db transactions, commit and rollback?</p>

You will get many varied answers here, but in MY OPINION access is just not there as a scalable solution.  It doesn't handle multi-user situations very well, as you start to approach 1Gb in size, stability starts to become a MAJOR concern, and in reality it just doesn't have the performance.
In regards to transaction support, please see
this Microsoft Artic
le.
Also, here is a article that actually points out a good majority of
limitations of access
.