Re: how to share server database with clients in a network...
Remove all tables and put into a seperate Access Database - this is the "Backend" database. Put this Database onto the Fileserver computer in a shared folder. Each Client computer should have a Network Drive mapped to this folder, using the same Drive letter(e.g "Z"). In the main (Frontend) Database goto "File" on the main menu, goto "GetExternalData - Link Tables", select the Mapped Network drive "Z" and follow the routine to create a link to all the relevant tables.
Now, when your Frontend Database is opened on a client PC it will connect to the data tables on the Server PC. Be aware, if the number of users goes over about 10 you may start to experience problems with performance.
Hope that helps.
multi-tasking - the ability to hang more than one app. at the same time.