Re: Permissions Don't Seem to Be Working
- From: "Joan Wild" <jwild@xxxxxxxxxxxxxxxx>
- Date: Thu, 1 Jun 2006 19:53:40 -0400
When you login, what is the username you are using?
Hit ctrl-g and type
?currentuser()
what does it return? also type
?dbengine.systemdb
what does it return?
--
Joan Wild
Microsoft Access MVP
VBA Dabbler wrote:
I have a database (2002 - 2003) with user-level security. When I
login to an account that is a member of the Admins group, I am
recognized as 'admin' by the system, which is not the username I
logged in with. I've embedded "MsgBox Workspaces(0).UserName" in a
VBA routine, and when executed displays 'admin' in the messagebox.
Furthermore, the remainder of the code in the routine will not
execute, erroring with "You do not have the necessary permissions to
use the '___' object." The object being a table.
I am extremely confused about what's going on here.
Can someone help?
Regards,
VBA Dabbler
.
- Prev by Date: Re: Cleared 'Admin' Password now can't open database
- Next by Date: Re: Help - Multi User Database
- Previous by thread: RE: Macro security in runtime version
- Next by thread: Re: You do not have necessary permissions error...
- Index(es):
Relevant Pages
|
