Link to home
Start Free TrialLog in
Avatar of Felix Kiprono
Felix Kiprono

asked on

Ms Access 2010 Setup (Executable file)

Hello. I have a project created using Ms Access 2010. I have created its executable file in Ms Access successfully.  I can therefore install it and it works perfect.  Now, if I wish to make a change/modification of certain module/form/report it becomes impossible.
 Advice me on how to make a setup that can allow me to modify it later on (eg prompt password for modification) For security the database has login form, so when opening the installed executable file for use, it prompts for Login credentials and this works well. But using The Project as it is, makes it possible for modification even on the login form as opposed to its .exe file.
I really wish to use the executable file for security purpose but want it modifibale.
Also advice me on MS ACCESS PROJECTS MANAGEMENT/MAINTENANCE AND DATA BACKUP so that I can make commercial systems out of this. Thank you experts
Avatar of Alex
Alex
Flag of United Kingdom of Great Britain and Northern Ireland image

Changing Your Data File
If you have direct access to the Data File, making changes to the tables is usually easy.  Your biggest task will be to make sure all users have exited their front-end databases so that you have full read/write access to the table design.

That help?
<<I have created its executable file in Ms Access successfully. >>

  Just to be clear, you cannot create an executable file.

 With Access, you can have a copy of the DB with the source code stripped out (.accde), but it is not an executable file.    Access needs to be installed on the end users system in either full retail form, or with the runtime edition.

 As for updates, you want your application "split" into a Front End / back end.  Front end has everything but the data tables, back end only has the tables.   By doing this, you can update the front end as needed without touching the data.

 The back end is typically placed in a shared network location and each user given a copy of the front end.

Jim.
ASKER CERTIFIED SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Felix Kiprono
Felix Kiprono

ASKER

thnks