how to share server database with clients in a network... please help..     

damn i forgot its a access database.. how could i share it using vb6... need help...   

Hi,
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.