Need Help with Programming in Access

what version of access. surf to support.microsoft.com. search the knowledgebase for your version of access and try keywords like multiple user
maybe it should be working prototype for your sql database

Use the database splitter to split the tables from the frontend. When prompted to save the backend, save it to the network location. (You can save it locally, also, and then relink later using the linked table manager - but either way, do this prior to distributing your app). The locking should be optimistic (generally the default). Once you have split the db and the backend (tables) are in the desired location, distribute the app to your users. They should now all have the same table links as the links are controlled from the frontend (Forms, Queries, Reports, Macros). This scenario also helps you in you future dev - changes made to the frontend will not affect data - just make sure that the table links are correct when redistibuting.