security Issue Help Please.....!!!

[khaksar]

Dear friends,

I have a Data base made in Acess. Now every body is accessing that DB from
his PC and it is lying in a shared drive of one PC. Now i want to make users
such that whenever any body want to open th DB he/she should be Log in to the
DB. For such purpose i have to make users but i donot know how to make users
and give then sepcific and limited rights of the DB.

Early responce will be highly appreciated.

Regards,

Khaksar.

 

[Scott McDaniel]

Dear friends,

I have a Data base made in Acess. Now every body is accessing that DB from
his PC and it is lying in a shared drive of one PC. Now i want to make users
such that whenever any body want to open th DB he/she should be Log in to the
DB. For such purpose i have to make users but i donot know how to make users
and give then sepcific and limited rights of the DB.

If you haven't aleady done so, you'd be well advised to split the database into FrontEnd (forms, reports, queries,
modules) and BackEnd (tables only) and distribute a FE to each user. All FEs will connect to the same copy the BE.

You can use User Level Security to do what you wish; it's a pretty tricky subject and can easily trip you up, and will
require some coding to achieve what you want. Check Joan Wilds site: www.jmwild.com. If you're looking for a good read
on the subject, try Gerry Robinson's book: http://www.vb123.com/map/.

Early responce will be highly appreciated.

Regards,

Khaksar.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com