Problem using Access in Active Directory
Has anyone else had issues with Access when you logoff local user and login
to Active Directory?
System info:
Front end: Windows XP, Service Pack 2
Back end: SQL Server 2003
Access 2007
Event: I have been running quite successfully an application built with VBA
and macros. I have had no problem running it until I had to move to Active
Directory. The application stopped running my macros and it told me that
"The database cannot be opened because the VBA project contained in it cannot
be read." It threatened to delete "all code from modules, forms and
reports..." Naturally, I told it not to do that.
When I login as local user, no problem. It likes me, I like it, we have fun
together. But in A.D., you would think that it never knew me!
I have tried to tell Access that all of my work can be trusted, but I guess
he doesn't believe me.
Can any one help!!
Thanks!
fs
.
Relevant Pages
- Problem with Access in Active Directory
... to Active Directory? ... I have had no problem running it until I had to move to Active ... When I login as local user, ...
(microsoft.public.access.modulesdaovba) - Re: Is_Member problem : Does user belong to custom Group
... In active directory: 1 - Created in Active directory a Windows group named ... 'MyDomainName/MyApplReadOnly' as Login Name and the same as User ... We can create a ROLE in the database and add the users. ...
(microsoft.public.sqlserver.security) - Re: Is_Member problem : Does user belong to custom Group
... - Added in Security/Logins the windows Group 'MyDomainName/MyApplReadOnly' referred as type 'Windows Group' with Defaultdatabase 'Master' ... Then configured the database Role Membership of this user by setting db_datareader and db_denydatawriter to true. ... for the current user returns 0 although he is referred in active directory as someone belonging to the the windows group Mydomainname\MyapplReadOnly ... There is a login, there is a user that mapped to the Login ...
(microsoft.public.sqlserver.security) - Re: New to Active Directory
... So how does the login process work? ... A user will have a local workstation username/password. ... connect to Active Directory, ... In an Active Directory environment one computers ...
(microsoft.public.windows.server.active_directory) - Re: Eliminating multiple logins in VB6 with SQL svr
... In the login screen I use an API ... I need to check the user name when my app starts to limit their recordset ... initially put their active directory user names into the table to match up ... Dim lSize As Long ...
(microsoft.public.vb.general.discussion) |
|
