>If I didn't install it on the server, so how the other user will access it, it is a multiuser system and everyone should access it via the network, what to you advice Eric.
User access what? Database must be placed in a shared location but the application can/must be deployed to every user workstation (or else you need an Internet solution).
You can have components (ActiveX DLL or EXE) that runs on a server that are accessed through DCOM or you can install MTS on your server and install your DLL components in it.
>and is it the correct way in VB to do one big .exe file ??
Is that correct to eat 2 bigmacs at McDo? It depends on a lot of factor! Creating one .EXE can be good is some situation and can be disastrous in other.
That kind of question needs a good architecture and a good thinking before writing the first line of code. You should consider having courses on that subject (see
http://www.microsoft.com/trainingandservices/syllabi/syllasearch.asp?PageURL=/TrainingAndServices/syllabi/content/1016Afinal.txt for a good course on that)
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com