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…