Standalone Application (1 Viewer)

Taffski · Jun 15, 2011

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 · Jun 15, 2011

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 · Jun 16, 2011

Many thanks for the heads up and the prompt reply.

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

Mr. B · Jun 16, 2011

You are very welcome.

Good luck with your project..

Taffski · Jun 17, 2011

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 · Jun 17, 2011

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 · Aug 18, 2013

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

Standalone Application (1 Viewer)

Taffski

Registered User.

Mr. B

"Doctor Access"

Taffski

Registered User.

Mr. B

"Doctor Access"

Taffski

Registered User.

Mr. B

"Doctor Access"

eirman

Registered User.

Similar threads

Users who are viewing this thread