Marie said:
Has anyone had any problems using an Access 2003 mutliuser shared datbase
stored on a SAN?
I've used a NAS, but not a SAN. I would guess however that problems might
exist if the SAN were located outside of a LAN, since the bandwidth would
probably be limited, especially in a multi-user environment. Several things
that you need to look for before checking to see if the IT dept, is in any
way throttling bandwidth even more (assuming a local network).
1. Make sure that your database is split and the front-end is on each user's
workstation with the data tables only residing in the network drive. This
can't be overly stressed. If you don't split your database, you run a higher
risk of corruption.
2. Make sure that every query used an indexed criteria to return data. You
almost never need to return every possible row.
3. Make sure that you have intelligent indexes on fields which may be used
for criteria.
4. There's some other performance tips at:
http://www.granite.ab.ca/access/performancefaq.htm