Pradeep- Considering I wrote an entire book on this subject, giving you a full answer on email is going to be difficult! <s> 1. Depending on what your application does and how you have it designed, you can support as few as 2 or as many as 50 or more concurrent users. To get above 20 concurrent users, you probably need to use unbound forms and reports. 2. You must design security to your needs. If you simply need to let some people use the application and others not, use Windows security. If you must control who gets to what parts of the application, use a combination of Access security and application code on top of that. 3. Problems: A poorly designed client/server application will have lots of problems - particularly with performance. Your network must be rock-solid - never use dial-up and use VPN only if broadband. Does that help? John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/
_____ From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of pradeep reddy Sent: Friday, June 16, 2006 2:58 PM To: ms_access@yahoogroups.com Subject: [ms_access] MS Access on a Shared Network Drive Hi, does anyone currently use an Access DB on a Shared network drive? If so, how many users have access and how is security set up? Do you use windows security or is security established through the Access application? Do any of the users have problems accessing network shared drives and if so, do you know why, hardware, PC related..etc. Any recommendations? Thank you! -Pradeep --------------------------------- Do you Yahoo!? Next-gen email? Have it all with the all-new Yahoo! Mail Beta. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Something is new at Yahoo! Groups. Check out the enhanced email design. http://us.click.yahoo.com/SISQkA/gOaOAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/