i only have knowledge of connecting into a database(singel PC)
but i have now idea where to start when my database needs to be centralized(1database for many PC) or (Network, LAN connected database)

can any1 help me on how to make this,

my code for connecting a database to VB is below
what do i need to change?

prov = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\MAINDB2.mdb" & ";Persist Security Info=False"

also after asking people in school how to do this,

they only told me of using DSN

but what is DSN?