Really Easy Network Question

[trophyfish]

I have a simple VB6 program running with an Access DB. I never designed the program to run over a network because I don't know enough about how to do it. My question is, could this program be loaded onto a server and be run on multiple clients at the same time? My concern is multiple users (maybe 3-4 users) trying to read and write to the Access DB at the same time.

[Hack]

Originally posted by trophyfish
My question is, could this program be loaded onto a server and be run on multiple clients at the same time?

Have you hard coded the Db path?

If not, then, theoretically, yes.

There are other issues that I can't specifically address because I don't have any details about your application.

Try it.

See what happens. (don't remove the local copies, however, until you are sure your network version is working. Also, if this application is currently in production, and run locally on 3-4 machines, then 3-4 different people are going to have 3-4 different records in their local Db. You'll need to find a way to incorporate all their records into one Db.)

[trophyfish]

no hard coded DB path I am using app.path &...\DB.mdb and a sophisticated installation prog.

My question is: if I install my app only on the server and create short cuts to my exe file from a client will the program run and could this be done on several more clients at the same time. Yes I want all users to be accessing the same DB and there would only be one DB under this scenario.

[trophyfish]

Can't test it cause I don't have a network and I don't want to sound like too big of an idiot when I try to explain this to a customer.

[Hack]

Sir, if you can't test it, don't try to sell it.

[Conscript]

You would probably have to do some re-coding.

is the database going to be located on a server like SQL Server or MySQL? If so, then I suggest using ADO. To test it get a webhost of some sort (www.brinkster.com is good) and test it with it.