Chempax User cannot Export from Access

Chempax User cannot Export from Access

The version of Access being used is installed at the Server level, therefore the version of Excel is also installed at the Server level.  There is no communication with local user installations of Access or Excel.  With this in mind, we looked at the elements of server permissions.

1.) Active Directory: Is the user in Active Directory with proper permissions
2.) With user in Active Directory and having proper missions... Identify where permissions are stored for each user (Originally assumed they are stored in group policy -- not true) the permissions are stored in the user folder.
3) Does the user have a local user folder? If no, they rebuild the user profile and a new folder will be built as the user logs in for the first time. Requires deleting user from Active Directory, forced Active directory cleanup, and adding the user to Active Directory, and logging in as the user.
Once completed the RDP session now has the proper permission to use the full access of the Server, and all software on the server as permissions allow.
    • Related Articles

    • Unable to Export Chempax Report Data to Excel

      The version of Access being used is installed at the Server level, therefore the version of Excel is also installed at the Server level. There is no communication with local user installations of Access or Excel. With this in mind, we looked at the ...
    • Adding a user to Purchase Order Request in Claromentis

      1. Open the intranet.sbv.us.nidec-sankyo.com (from any browse and any computer) and login using username:tubesock and the usual tubesock password   2. Click on the Applications icon (icon that looks like calculator -- upper left area of the page -- ...
    • Restore a Deleted User in AD 2012 r2

      Verify the username is not found in Active Directory by selecting Active Directory and the domain and right click on the domain and search for the username, not the users name, but the email name that is used for login. Once confirmed, perform the ...
    • County Office 365

      Once the user is created in County2012-DC,  Open the account Click on the attributes tab Scroll to proxyAddresses and double click add  SMTP:user@co.shelby.in.us x400:C=US;A= ;P=County;O=Exchange;S=UserLastName;G=UserFirstName; This tells the ...
    • Cache Error in Odyssey (Clear Odyssey Cache)

      Fist login as the User and then... 1.)  Clear the Internet Explorer cache via Internet Options. 2.) Click Start and in the search box type:  %localappdata%\ 3.) Click on the folder Tyler Technologies  4.) Click on the folder Odyssey 5.) Click on the ...