Access Front/Back End? advise needed.

[SukhiRehal]

Access Front/Back End? advice needed.

Hi guys,

I’m hoping someone can help/advise me here.

Basically I have a database which I’ve created and now I want to share it with other people but I want to limit what they can do, for example I want other users to be able to view data but not change it.

I have done some reading and it seems that what I’m after can be achieved through creating a front end/back end database. (Correct me if I’m wrong in assuming this)

I can do this by splitting the database using the tool within MS Access.

However I am not to sure how I can implement the limits to what users can do/not do.

I hope I’m making sense.

Any help or guidance is appreciated.

Also I am using MS Access 2007.

 

[spoole]

Splitting a DB does not always make it more secure, it simply seperates the DB into tables (back end) and forms (front end) To secure your database, as you have said, will be preventing users from altering data in the tables.

All data that users see should be in a form or a report. A form however can be used for both data input and displaying data. To secure a form from allowing users to change data you need to "Lock it Down" Do this by right clicking on each textbox/combo box etc and changing "Allow Edits" to disabled

*******NOW TAKE A COPY OF YOUR DB*********

Once you are happy that the data is "Locked down" then you split it.

PS also do a search on "data validation" if you are splitting DBs for use in a network environment you need to assume the user can and will make mistakes and preventing this "dodgy" data from entering the DB is a must.

 

[SukhiRehal]

Spoole,

Thanks for your reply, once this is done do you reccomend just hiding the tables/ forms that you dont wish the end users to see?

 

[spoole]

Yep, although with a little knowledge a user could get round that

 

[SukhiRehal]

Would you do it a different way?