have developed an access database whereby multi users are using via front end application. I have split the databse into back end and front end.
problem is each time i make a change to the front end, I have to go to each pc to update. Apart from this, any other programmer can easily see all my workings and can copy my database.
I want an option whereby when i make any changes to the front end, then the user will get the change upon the next login. I was thinking of using the front end over the local intranet web browser. will have one front end and all users will be connected to that. any changes i make will be on that front end and they will see the change upon next login.
My other problem is that I do not want the front end to be stored at the user's end as any programmer can access my tables, forms, queries, reports, macros even if i disabled the navigations option.