Printable View
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.
Have you hard coded the Db path?Quote:
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?
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. :D (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.) :p
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.
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.
Sir, if you can't test it, don't try to sell it.
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.