Preferred way of Running Ms access project

[felixkiprono402@gmail.com]

hello guys, I have recently completed a School Management System using Ms Access 2010. My worry is file corruption by virus or even illegal records manipulation by users. The school where the project belongs to are not serious in investing in antivirus installation. So i fear installing the system directly on their PC and was looking for an alternative ways of using the program in a CD. Is burning the project on a CD-RW appropriate and more secure than direct installation? Please help. Nice day

[CJ_London]

Is burning the project on a CD-RW appropriate and more secure than direct installation?

I wouldn't think so - and it will be very slow since the RW speeds are slow.

Your application should be split, front end and back end. Backend contains data (i.e. tables) only and is located somewhere all users have access to. Front End is everything else and a copy located on each users machine.

To make your front end more secure, create a .accde. But you also need to make sure users do not have access to the navigation pane and ribbon. If they are using runtime, then OK, they won't see these if you supply a .accdb, but nothing to stop them taking a copy and putting on a machine that has a full version of access.

To make your backend more secure, password protect it - but that won't stop someone from deleting or copying it

You need to be clear about what you are protecting, from whom, why and by what means - i.e. do a risk assessment and develop a clear strategy for dealing with it.

If data security is highly important you may want to store data in sql server express (it's free) for example.
If you are concerned about hackers, ensure that you have protection against sql injection - and do daily backups of the back end if your IT dept isn't doing it
The only protection against viruses would be a decent anti virus application - they are not expensive, particularly when set against the cost of recovery


There are plenty of threads on this and other forums on this subject.