Is there anyway to lock a query such as password protect to keep others from running it?
P Pammy Jul 10, 2008 #1 Is there anyway to lock a query such as password protect to keep others from running it?
J Jerry Whittle Jul 10, 2008 #2 Yes. But for that to work you must have user-level security implemented. Not easy. http://office.microsoft.com/en-us/access/HP030663091033.aspx
Yes. But for that to work you must have user-level security implemented. Not easy. http://office.microsoft.com/en-us/access/HP030663091033.aspx
K Klatuu Jul 10, 2008 #3 Jerry's answer is correct. But, if your users have access to the database window and can run queries from there, you don't really have an application. Users should be restricted to working through forms and menus you provide for their navigation.
Jerry's answer is correct. But, if your users have access to the database window and can run queries from there, you don't really have an application. Users should be restricted to working through forms and menus you provide for their navigation.
