You are most welcome.
What i
initially wanted to have everybody access it from share drive but now
that i know the better way is to install it on each machine.
To be honest, some people have said they had no problems doing this.
However, we OFTEN see all kinds of problems when this is done.
It is one of those risk factors. For some reason, acces97 seemed to
tolerate more then one user in the mdb/mde file. For some reason, a2000 and
later does not take well to this at all. I don't want to sound harsh...or
say you "must" do this. However, it is just a good idea...and if you came
back and said:
But..it is more work to distribute those stupid files to each machine.
You mean I have to walk around and put the mde on each machine?
I would 100% agree with you!!.
This is one pain issue, but a tradeoff for much more reliability!!! So, the
solution is then to have some code to "copy" the new Front end to each pc. I
rolled my own code in the ms-access application (it would check a version
number in the back end). However, Tony has a nice free updater here that
will solve this problem for you here:
http://www.granite.ab.ca/access/autofe.htm
Also what
about .exe file? Would that be a posibility? If so, would you recommend
it ? If so, how would i achieve it?
There is no ability to create a small single .exe file from ms-access. You
can however purchase a royalty free runtime system for ms-access. This will
allow you to deploy a mde on a pc that does NOT have ms-access installed. So
there is no such thing as a .exe file here. The access runtime is rather
large (34 megs in size -- so, it is essentially ms-access without the
ability to modify forms). I suppose you could re-write the application in
something like VB, as that then would get you a .exe file. (but, VB does
also requite a runtime system also) . So, other develpuemnt tools like VB6
will create .exe files, but I don't think this is an advantage here. And, VB
is missing a lot of things like a nice report writer we have in ms-access.
And, if your question was can you share .exe file on the server? This again
is something that companies did do on occasion many years ago..but
today...we simply put the .exe files on each computer for all of the reasons
mentioned (reliability...less bandwidth etc.).