What are steps to take my MS Access Application like a Custom Software Application
What are steps to take my MS Access Application like a Custom Software Application
A very broad question - depends how far you want to go. Some of the things to consider
don't use newly available functionality not available to users with earlier versions of access
hide the access window
split your db
ensure you have full error handling
make your front end .accde
protect the backend with password
make sure it will run and has the functionality available if user only has runtime access. Runtime does not have certain functionality such as right click menus - so you need to write your own
you may need 2 versions for 32 and 64 bit access
late bind everything you can (such as references to excel/word/outlook etc)
use a suitable installer package to distribute your app
This is a question and shouldn't be in the code repository. Mods may wish to move it to a better location
I agree with everything Ajax has written.
You should also consider security such as hiding the navigation pane and ribbon.
It is also possible to hide the entire Access application interface so your app is 'floating' on the desktop.
However it is worth stressing that an Access database can never be a standalone application.
Users will always need either a full version of Access or a runtime version in order to run your app.
EDIT: The post has now been moved
Last edited by isladogs; 08-02-2020 at 10:12 AM.
How can i hide the ribbon
Please forward the tips to hide the ribbon,
when cancel button in parameter query dialog box pressed, there is blank screen appeared, how can i solve this
Have a look at my example database which includes code to hide the ribbon and much more http://www.mendipdatasystems.co.uk/c...ace/4594365418.
I rarely use parameter queries, partly for that reason. Your end users should NEVER open tables or queries directly.
Instead get users to select from the available choices using one or more combo boxes or listboxes.
The selected choices act as your parameter(s) and are used to display filtered results on the form or a subform
Thank u very much