• unregister a dll and an ocx file

    Author
    Topic
    #352381

    I am trying to resolve an issue with sending contacts data from access to a public shared folder in outlook, and along the way in pursuit of this solution, tried to implement a solution provided on a website. this solution involved using regsvr32 to register two files: SyncADO.dll and SyncADOOptionsPage.ocx. What all this results in is that Outlook tries to sync contacts to a Access database on startup and it is supposed to provide a custom tab in the Folders | Properties dlgbx.

    I want to uninstall this as there may be an easier way to do what I am trying to do, but I can’t figure out how to do it. Is there an unregsvr32 command?

    Viewing 2 reply threads
    Author
    Replies
    • #512324

      Steve,

      Try:
      regsvr32 /u SyncADO.dll

    • #512325

      I figured this out on my own. Thanks tho!

    • #512476

      Steve,

      Would be so kind as to reveal the source of the SyncADO.dll and SyncADOOptionsPage.ocx library? I could use this too if you can sync to a SQL database as well as Access db. Thanks.

      • #512499

        I got those files in a package from this article:

        http://exchange.devx.com/upload/free/featu…9900/rb9900.asp

        It is very informative, but I had trouble getting it to implement. When I installed it, there was a new tab in the folders | properties dlgbx but it had the nice little effect of freezing outlook when accessing it. anyhow, if you try it and don’t get it to work, you can uninstall it via the COM Add-In in Outlook.

        What I really need is a way to programmically find a sub-folder (Contacts folder) in a public folder on the Exchange Server. The code I always find is

        Set fldContacts = nms.GetDefaultFolder(olFolderContacts)
        Set itms = fldContacts.Items

        Which is fine for porting Access data to the default Contacts folder in my Inbox, but that is *not* what I want to do. I noticed that the folder I am trying to get to has this path reference:

        HHSC ContactsCRCGLocal Kids Chairs, and that *looks* like a UNC path. Now to place the path reference in the VBA code… actually, I haven’t tried it yet. Another problem is getting the Contacts field in Outlook to take data from the same field in Access, but one step at a time…

        • #512624

          Nothing to do with your dll/ocx problem but maybe of use to you is the objFolder = objNameSpace.PickFolder command. this will open up a familiar dialog letting the user choose the public (or personal) folder they want to target.

          I have a database that uses this to export 1300 contacts details to a company public folder. It takes 10 minutes or so and i am sure there is a better way to create the items.
          Currently i have to create the item in the personal fodler and then move the item to the public folder. I have posted questions on forums in the past to find out why i am unable to create the item in the public folder in the first place but no answers yet. If you get it working would you please let me know?

          • #512678

            I found out how to unregister the dll and ocx files, or at least knock them out of Outlook, so that problem is fixed.

            your method for posting an access record to a public folder does work — thanks! i’d still like to be able to map directly to a public folder without the navigation step, but at least i can get most of the job done.

            i take it from your response that you have implemented this in a way to do batch transfers… how do you deal with making lots of duplicate records in the public folder? I am really looking for a way to synchronize the public folder with an access table, or at least chack for duplicate records before posting, etc.

            also, i find that invoking the PickFolder command switches over to Outlook, so I put in a SendKeys alt-tab command to switch back over to access to complete the VB module.

            anyhow, thanks again for the code snippet.

            • #512836

              Steve, nice idea with the sendkeys alt+tab, i hadnt thought of that but will put it in place soon!
              I had a dilema about synchronising the two sets so i experimented with olFolder.contactItem.delete to clear the folder out first.
              The delete takes only a minute or so, so is no great impact on time in itself although the export is complete rather than a sync of changes made so that takes longer than it might.
              I have set the Outlook Folder to Read Only to the whole company so there are no changes to bring back from there which means a oneway export works.

              If anyone can tell the two of us how to export to a Public Folder without the hop from the personal folder first there will be two very pleased developers !!
              HAS ANYONE GOT ANY IDEAS ????
              Heres hoping !!

        • #512625

          Also…. what is the field name for the big blank space on a contact? I have contact details that would fit in well here but cannot locate the field name – notes, description i dunno…?

          • #512647

            In Form design view it’s called Notes, but whether that’s the field name or simply a display name I’m not sure.

          • #512904

            That field is also called ‘Notes’ in the import wizard in Outlook, so it should be mappable in a VB program. I borrowed Helen Feddema’s program for exporting to Outlook from Access and the VB coding you might be able to use should look something like this:

            Dim strNotes As String <– in the preliminary declaration of constants

            strNotes = Nz(Me![you access field name here]) <– in the mapping loop for applying Access fields to a constant for applying to the Contacts form in Outlook

            .Notes = strNotes <– in the loop for porting your Notes in formation into the Contact form field '.Notes' No promises that this will work, however — I have not been able to get the .Company form field to accept data.

            If you need more information on Helen Feddema's code, let me know.

          • #512905

            That field is also called ‘Notes’ in the import wizard in Outlook, so it should be mappable in a VB program. I borrowed Helen Feddema’s program for exporting to Outlook from Access and the VB coding you might be able to use should look something like this:

            Dim strNotes As String <– in the preliminary declaration of constants

            strNotes = Nz(Me![you access field name here]) <– in the mapping loop for applying Access fields to a constant for applying to the Contacts form in Outlook

            .Notes = strNotes <– in the loop for porting your Notes in formation into the Contact form field '.Notes' No promises that this will work, however — I have not been able to get the .Company form field to accept data.

            If you need more information on Helen Feddema's code, let me know.

    Viewing 2 reply threads
    Reply To: unregister a dll and an ocx file

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: