Question Multiy Users/logins for Access 2010

[ClairH]

Hi

I wonder if you can help me please?

I've been building a db for quite a while and I've been asked by the Management Team if I can create a "home page" version of the database saved to our shared drive, where others can run reports etc, but not actually access/mess with my db.

Is that possible? I'm pretty sure I could in Access 2003 which we were using before, but I've had an accident and they've upgraded to 2010 whilst I was off.

Thank you
Clair

 

[CJ_London]

your db should be split frontend/backend with the backend on your network and a copy of the front end on each users pc. It doesn't sound like you have done this, but once done you can have as many different front ends as you like accessing the same backend.

If for ease of maintenance you only want the one version of the front end, you can implement a security process to identify the user and then allow or deny access to various forms/reports and set the read/write permissions as required - quite a big subject.

but not actually access/mess with my db

This is also a big subject but an easy fix to prevent messing with forms/reports/code, create an accde front end.

To prevent direct access to tables and queries is more involved, but basically involves hiding them in a number of different ways. It will stop many people but someone determined will be able to 'break in'. If you are concerned about security consider migrating the back end to a secure server such as SQL server or MySQL.