Access Vs SQL

[Victor Cheung]

If I have 10+ computer network.. and the vb program is local in each
workstation and the database is in the main filer server.. should I use SQL
and Windows 2000 Advance Server.. Or Access And Windows 2000Professional..

Also, My vb program is in one big exe file.. the file size is 80Meg.. will
it create problem.. when it access the database on the file server? also..
how can I make the file size smaller or put some code in some other files?
also.. somehow.. I need to install visual basic on the computer.. in order
for the program to run properly.. any idea why?

Thankz..

 

[Dan Artuso]

Hi,
answers inline...

If I have 10+ computer network.. and the vb program is local in each
workstation and the database is in the main filer server.. should I use SQL
and Windows 2000 Advance Server.. Or Access And Windows 2000Professional..

That depends on a lot of factors, I can't give you a definitive answer.

Also, My vb program is in one big exe file.. the file size is 80Meg.. will
it create problem.. when it access the database on the file server? also..

The file size of your exe will not affect database access

how can I make the file size smaller or put some code in some other files?

You can place routines in DLLs, but you still have to distribute these DLLs with your app.

also.. somehow.. I need to install visual basic on the computer.. in order
for the program to run properly.. any idea why?

Yes, you have to make a setup package and then run that to install your app on other PCs.
VB depends on other files being present in order to run. There is no such thing as a stand alone exe with VB


Get a good book on VB to learn how to do all the above.