Local mdb file

We have an MS Access 2010 database on a server, and then on the local computers on the network
We have a Front end Access Database that's linked to the server,
what's the best way when I am making changes on the front end I shouldn't need to go all computers and
copy over the new mdb file, how can I do it from the server to copy over the new mdb file to all computers from the network.
Thanks in advance.    
Frimy
LVL 1
frimyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
try using the AutoFE updater

http://www.autofeupdater.com/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
John TsioumprisSoftware & Systems EngineerCommented:
Well you can always make a central repository and xcopy the Front End to the users when they log on...
0
PatHartmanCommented:
I use a batch file.  On their desktops, the users have a shortcut to a .bat file on the server.  When they click on the shortcut, it executes the .bat file.  The .bat file creates a local directory, deletes the existing copy of the FE, copies the current production version from a network location, starts the database it just copied.  

The first step is there so we can use the procedure for new users.  The second step is there for existing users.  Neither will fail if the directory already exists or the file to delete isn't actually there.

md c:\ClientMgt
del c:\ClientMgt\AOAClientManagement.accdr
copy \\newfiscal\Afox\AFox\AccessApplications\ClientMgt\AOAClientManagement.accdr c:\ClientMgt
c:\ClientMgt\AOAClientManagement.accdr

Open in new window


The FE extension is changed from .accdb or .accde to .accdr by simply renaming it.  The purpose is to coerce Access into always behaving as if it were the run time engine.  This keeps klutzy users from accidentally breaking things if they manage to get them into design view.  The .accdr prevents Access from being able to open any object in design view.
1
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
To further the above comments a bit from Ray and John, Auto FE updater is well thought out, has a lot of features you need, and works extremely well.    The price for it is more than fair, even though some might consider it high.

But as John pointed out, a simple file copy in a batch file is all you need.   For many years, I used a setup like that.

What I'd do is have a version control table local to the FE (tblAppVersionControl).   Then I would create a link to the same table in a "master" FE on the server (tblAppVersionControlNet).

  I'd compare the Dmax() of the version field, and if they didn't match, would message the user that they needed to update.  The "update" was nothing more than a shortcut to a batch file on the server.  They'd execute, new FE would be copied down, and now the app would start because the versions would match.

 Only down side; it wasn't "in-place".  Users needed to exit the app and execute the short cut.

 AutoFE works by the "launcher" method; a small .EXE starts first, does all the checks and what not, then starts up your DB.  That method gives you a few more options in controlling things.

Jim.
0
PatHartmanCommented:
The .bat file I posted works quite easily and doesn't ask the users to do anything.  We also use one for our Citrix users (with different paths). The FE's of split databases (I hope you compact before you distribute) are small enough that they don't take more than a couple of seconds to download and open.  The upside is that I never have to worry about the FE bloating or needing a CR.  The users get a new copy at least once per day.
0
Gustav BrockCIOCommented:
We use a method similar to Pat's. Zero trouble, zero cost, will never fail, always up-to-date frontend.

/gustav
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
There are pro/cons to all of the approaches.  The take away is that it's easy to do and you have a range of options for doing it.

Jim.
0
aikimarkCommented:
I have an app at a client site using an update-needed method similar to what Jim described.  In my case, I'm looking at the name of an empty text file in the same directory as the BE database.  The name describes the app version.  This way, I don't even get to the open (BE) database activity unless I know that the FE is the correct version.

The initial form hides the initial form, displays a msgbox, closes the database, and quits Access.
0
aikimarkCommented:
Note: I also have a timer in a hidden file that looks for any change in the app version file name or the presence of a app stop file name out on the server.
0
frimyAuthor Commented:
I've requested that this question be deleted for the following reason:

i found a solution
0
aikimarkCommented:
@frimy

What was the solution that you found?
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Which is?

While it's great that you found a solution, it's even better when you come back and post it so everyone can learn.

So please post what you found worked, then select your own comment as answer.

Thanks,
Jim.
0
frimyAuthor Commented:
I like you ALL,
My solution was to put it on hold for now.
I thought it's something simple.
But i see it will take time to test and implement it and we are very busy now.
Thanks again
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.