B
Bender
Does anyone have any links regarding how to limit a users access in MS
Access 2007?
Access 2007?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dale Fye
Limit their access to what?
This is problematic with Access 2007, since if the application is not in a
trusted location, or is not signed by a trusted publisher, then Access
automatically opens with macros disabled, displaying the ribbon, navigation
pane, and the "Options" button (which will allow you to enable macros).
However, if the user doesn't enable the macros, then they have access to the
navigation pane automatically, although I think you can hide that in the
Options.
This is problematic with Access 2007, since if the application is not in a
trusted location, or is not signed by a trusted publisher, then Access
automatically opens with macros disabled, displaying the ribbon, navigation
pane, and the "Options" button (which will allow you to enable macros).
However, if the user doesn't enable the macros, then they have access to the
navigation pane automatically, although I think you can hide that in the
Options.
B
Bender
Limit theiraccessto what?
This is problematic withAccess2007, since if the application is not in a
trusted location, or is not signed by a trusted publisher, thenAccess
automatically opens with macros disabled, displaying the ribbon, navigation
pane, and the "Options" button (which will allow you to enable macros).
However, if theuserdoesn't enable the macros, then they haveaccessto the
navigation pane automatically, although I think you can hide that in the
Options.
My apologies if I was unclear, I am new to Access 2007. I would like
to block standard users access to the under lying DB tables, Queries,
Macros, Form & Report Design features. I just read that 2007 has
removed the User Security component. I am going to assume means that
I'll more than likely have to create a custom "Log In" form using VBA
script to validate user log in and restrict access to a Switchboard
(unless you sign in as an admin).
G
Gina Whipp
Bender,
Access 2007 has the Runtime available for free. Here's some reading...
http://msdn.microsoft.com/en-us/office/bb229700.aspx See if this gives you
what you want.
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" - Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
My apologies if I was unclear, I am new to Access 2007. I would like
to block standard users access to the under lying DB tables, Queries,
Macros, Form & Report Design features. I just read that 2007 has
removed the User Security component. I am going to assume means that
I'll more than likely have to create a custom "Log In" form using VBA
script to validate user log in and restrict access to a Switchboard
(unless you sign in as an admin).
Access 2007 has the Runtime available for free. Here's some reading...
http://msdn.microsoft.com/en-us/office/bb229700.aspx See if this gives you
what you want.
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" - Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Limit theiraccessto what?
This is problematic withAccess2007, since if the application is not in a
trusted location, or is not signed by a trusted publisher, thenAccess
automatically opens with macros disabled, displaying the ribbon,
navigation
pane, and the "Options" button (which will allow you to enable macros).
However, if theuserdoesn't enable the macros, then they haveaccessto the
navigation pane automatically, although I think you can hide that in the
Options.
My apologies if I was unclear, I am new to Access 2007. I would like
to block standard users access to the under lying DB tables, Queries,
Macros, Form & Report Design features. I just read that 2007 has
removed the User Security component. I am going to assume means that
I'll more than likely have to create a custom "Log In" form using VBA
script to validate user log in and restrict access to a Switchboard
(unless you sign in as an admin).
B
Bernd Gilles
Bender said:I just read that 2007 has
removed the User Security component. I am going to assume means that
I'll more than likely have to create a custom "Log In" form using VBA
script to validate user log in and restrict access to a Switchboard
(unless you sign in as an admin).
... only if you use the new accdb-format.
But you can use the "old" mdb-format and your workgroup files - even
with Access 2007.
With this, security should be the same as with Access <= 2003.