Printable View
We have a vb front end which is used to access a database in SQL Server 2000.
Every time a change is made to the front end we have to re-install the front end on the users PC's, would it be possible to get around this, and if so how? Or would we have to go web based with a different front end to access the database?
Create a network share that is accessible to all users on your network. Then place the exe in there. The users will only need a shortcut to this exe. The need to update it will only need you to replace the exe on the net share and thats it unless you have added some dependancies or controls etc.
Since its a net share and they users are only runnig a shortcut to it they are actually running the app on their systems so they wil need the dependancies and controls like I mentioned. Dont let then copy the exe down to their system or its self defeating.
So what you are saying is
1. I create a shared folder on the server with access for all my users.
2. I copy all the project files to that folder.
3. I create a shortcut on the users desktop to the projects exe within that shared folder.
4. Whenever I do changes to the project files I simply copy the changes over again to that shared folder overwriting the old ones.
Is it that simple?
Would they still need VB runtime files or something?
Yes 1-4.
And yes the workstations will need all the dependancy files/runtimes.
But once they are updated motly only ever the exe is updated so its allot easier.
Excellent, thanks VERY much for that, very very helpfull. :thumb:
I'd also package the app every time you make a change, and put it in the same place on the network. That way, if you add a new computer to the network you can just install the current version of the app and all dependencies easily.