Standalone Application

[Taffski]

MS Access 2010

Is it possible to save a DB created in MS Access 2010 as a standalone application (or at the very least a front end form) so that users not having Access installed on a local PC can access the data on a network server and Add, Delete, Edit records (as per any set permissions)?

Grateful for any assistance.

Many thanks.

Taffski (Permanent state of mind!)

 

[Mr. B]

The short answer is Yes. You create the database with a full version of Access 2010 as an .accde type file. Distritute that file to the users and have them download the free Runtime version:
http://www.microsoft.com/downloads/...cd-5250-4df6-bfd1-6ced700a6715&displaylang=en

You will need to provide all required interface as those using the runtime version can do nothing but the things for which you provide tools.

 

[Taffski]

Many thanks for the heads up and the prompt reply.

First bit completed; now on to distribution............wish me luck!!!

 

[Mr. B]

You are very welcome.

Good luck with your project..

 

[Taffski]

Runtime is opening the User Form on remote PCs and updating the data tables nicely. Many thanks for the assistance.

If I may go one step further.........the Cmd buttons don't seem to work in the runtime version so users can't search for specific records (of which there are > 14,500) and can't print reports.

Everything seems to be enabled in the Trust Centre in the xyz.accdb file before saving as xyz.accde.

Any ideas?

 

[Mr. B]

You may need to set the trusted locations on each machine that I running the runtime version.

Take a look at this link for how to do this when using the runtim version:
http://www.accessribbon.de/en/?Trust_Center:Trusted_Locations

Try this on one machine first and see if this helps.

 

[eirman]

Here is the link to the runtime version of Access 2010. The link isn't complete or clickable as this is only my second post.

microsoft dot com/en-us/download/details.aspx?id=10910

Here is the 2013 version
microsoft dot com/en-us/download/details.aspx?id=39358