vba & macros in access 2010 runtime

[Ramnik]

hello everyone ,
i have completed my database application and now i need to implement in my network . i want to know how to achieve this ?
method 1: access 2010 runtime
method 2: user log in system with multiple security levels .

i want to know if there is any issue with the vba & macros in access 2010 runtime ?
and how to implement multiple users with multiple user security levels . ?
thanks

 

[Ramnik]

Can anyone in this forum help me with this ? thanks ...

 

[Ramnik]

hello..... is there no reply to this thread ? its urgently needed ..
thanks

 

[Pat Hartman]

No one answered because there is no answer to the question. The two methods are not alternatives to each other. You have a misunderstanding of what the Access runtime is. The runtime engine is a version of Access.exe that allows a user to "run" the application using the forms and reports you have exposed but does not allow design view of any object. In order for an application to properly run under the runtime engine, it must be totally form driven and you must provide menus or a ribbon to give the user access to such things as the print setup dialog.

The Access runtime doesn't provide security for your application. Access files are portable and therefore can be copied and run on a computer with a full version of Access installed. That means if you want security, you have to implement it with program code. Keep in mind that anyone with determination can break your security so if your data is sensitive, it should be stored in SQL Server rather than a Jet/ACE BE.

 

[Ramnik]

Thanks but actually i asks for how to implement multiple user level security with vba ?????????? yes i understand the two things are different from one another but i want to know the best practices to implement the access application .

i have a more question that i implemented with access runtime 2010
i have a navigation form opens up which provides to open different forms & reports .
but i cannot open some of the forms in runtime although title heading apears but other content just goes blank . any help on this
thanks