Application's deployment HELP

[mapat]

Hello,
I have finished a program with ACCESS 2007 (VBA) at work. Now, my boss wants his employees to use it from different computers. What would I have to do to make this work?? I suppose ACCESS has a runtime version or executable that I can install on every computer of the company? Or do I have to install ACCESS 2007 on every terminal (which would be very bad by the way)?? I would appreciate it if somebody would give me a hand on this since I have never done this before.

Thank you very much

PS: All the computers are on a network

 

[g28dman]

Hello,
I have finished a program with ACCESS 2007 (VBA) at work. Now, my boss wants his employees to use it from different computers. What would I have to do to make this work?? I suppose ACCESS has a runtime version or executable that I can install on every computer of the company? Or do I have to install ACCESS 2007 on every terminal (which would be very bad by the way)?? I would appreciate it if somebody would give me a hand on this since I have never done this before.

Thank you very much

PS: All the computers are on a network

Someone may add to this. Access 2007 runtime is now a free download from microsoft, that would be installed on your local machines. You would split the db into a fe/be and load the FrontEnd on every machine linking to the BackEnd on your main server.

You might also want to look at error handling since you'll only be using the runtime. And, convert the frontends to a .mde file(dont know what it is for 07) Be sure to keep a master .mdb file to make changes.

You might want to search for the frontend auto-updating tool on this site, where you dont have to reinstall a new frontend each time you make a design change. You'll have to convert it to 07.