Multiuser Runtime

[Terry]

I understand that you can install a Access (2007) application on other
computers that do not have access installed by installing the Access
runtime.

Is there a way to keep the accdb (or mdb) file on a shared drive and serve
out that file to several computers if they have the runtime installed? It
would make my life easier if every time I make a design change I could
re-deploy to just the server instead of each of the 3 or 4 computers that
are running the app.

 

[Terry]

Thanks, I will give it try

Split the db file into front end and back end. Back end only has tables
and
relationships. Put that on the network share. The front end has
everything
else. Put a copy of the front end on each user's desktop. Use Tony
Toews's
autofe app to automatically update each user's front end for you whenever
you
deploy a new front end on the network share.

http://www.granite.ab.ca/access/autofe

You make your design changes, put the new file on the network share, and
autofe does the rest the next time each user opens the db app with the
Access
runtime. No worries. Users are never using an old version.

Chris
Microsoft MVP