Access Vs SQL

  • Thread starter Thread starter Victor Cheung
  • Start date Start date
V

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




Victor Cheung said:
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..
Click to expand...

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..
Click to expand...


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?
Click to expand...

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?
Click to expand...
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.
 
Back
Top