> If I expect 100-200 users, can the Access DB handle > this? Probably. It depends on how much work each user will be doing, and how many will be doing it at one time. If you're talking 100 users per week, evenly spread out across the week, you should be fine.
> Do I need to use CFLOCK around all queries? No. CFLOCK isn't for queries; the database provides locking and transactional functionality for individual queries, and if you need to group multiple queries within a single logical transaction, that's what the CFTRANSACTION tag is for. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
