Distributing Access file

[bernie10]

Hello all,
Could some of you share your thoughts with me as to what the best way is to distribute a final version of an Access DB to users. I want them having as little access as possible to tables, design views, etc. I just want them using the interfaces (forms and reports) that have been developed.

I know this is a very general question but this is my first time actually distributing an Access file I've developed to other users around my company so I was wondering if the experienced users might have any suggestions about things to be sure to do, settings to check, etc.

I've also seen some discussion about being able to distribute the file as a stand-alone application (though the users do have to have Access on their machines)... is this easily accomplished? How is this done?

Thanks for sharing your thoughts with me.

Collen

 

[ArkM]

About stand-alone app only: as far as I know you must have Office Developer edition or Visual Studio or MSDN Enterprise+ level subscription license to redistribute Access run-time modules.

 

[ZmrAbdulla]

[ul]
[li] No Stand-Alone in Access except run with Runtime Files that need Developer Edition Licence to distribute. [/li]
[li] Keeping intruders out from the database except forms & reports you need to create MDE file.[/li]
[li] Search for [/li]
[ul]
[li] Creating MDE files [/li]
[li] Disable Shift Key [/li]
[li] Startup settings [/li]
[/ul]
[li] If the db working under a network accessing a single backend db then it is must to utilize User Level security.[/li]
[/ul]
you will find a lots of posts in this regard in these forums

________________________________________
Zameer Abdulla
Visit Me
There is only one perfect child in this world. Every mother has it.