User Logins - Access preset or Custom build?

[Dan2kx]

Hello again,

I would like some opinions as title... what do people prefer? which is the easiest to use etc...

i am creating a multiuser holiday database, and the low level users must only be allowed to view their own holidays, and their departmental collegues, they must be able to reserve their own holidays, but only the supers can actually book the holidays, and creat new users etc,

i realise that the access security allows group management and permisions, but i cannot think of a way to link in the user to the staff id and only let them view their own...

if i were to create a bespoke login then i can visage a table with staffid, logon name, password etc and can use querys and If's to limit the access etc...

so what do you pro's think would be the way forward??

any recomendations would be createfully accepted

Thanks

Dan

[BOMEz]

From what I gather you want some persons to be able to view information only and others to be able to add information.

I would recommend using the built in security wizard for access 2003. It's a whole lot fast I would think than creating a table with login info.

I'm not sure how to tie in the desktop login though with the access login automatically.

[Dan2kx]

i don t need to tie in desktop, just access passwords,
i need users to only be able to see their own records and request holidays for themselves, but i want admins to grant/ deny the holidays and change user information etc

[MMcCarthy]

I'm not an expert on access security Dan.

However, you can retrieve the name of the current Access user with the CurrentUser() function. If you store this information in the user table you should be able to create a filter to only show records for the current user.