SSH (7/19/2011)
Ok Thanks, thats good to know that it works well.Did you use a ADP? I've read conflicting sources around using them.
Also, the reason of not impementing the whole thing within Access was due to needing concurrent access for up to 20 users, and I'd read although microsoft states it can handle 255 concurrent users it starts flaging well before that number. Am i right in thinking that using SQL Server Express 2008 as the back-end would alleviate/overcome this problem?
Many thanks
If your coding practices are good then you should be fine.
Like I said my in-house ERP was a low volume DB so even with 10 users there was no conflit, ever.
For 20 users I'd never use Access to save the DB. I'd certainly use ADPs with sql server to host the data.