Access Data Projects

I am working on my first Access Data Project (adp) and need to know if there is anything I need to be aware of when creating the stored procedures and user interface that might affect the performance. Specifically, are there limits to the number of users that may access a SQL server or run a stored procedure concurrently? How do you insure that users do not conflict with each other?