Results 1 to 12 of 12
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    unregister a dll and an ocx file

    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?

  2. #2
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: unregister a dll and an ocx file

    Steve,

    Try:
    regsvr32 /u SyncADO.dll
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: unregister a dll and an ocx file

    I figured this out on my own. Thanks tho!

  4. #4
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: unregister a dll and an ocx file

    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.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: unregister a dll and an ocx file

    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...

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: unregister a dll and an ocx file

    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?

  7. #7
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: unregister a dll and an ocx file

    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...?

  8. #8
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: unregister a dll and an ocx file

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

    Microsoft MVP - Excel

  9. #9
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: unregister a dll and an ocx file

    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.

  10. #10
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: unregister a dll and an ocx file

    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 !!

  11. #11
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: unregister a dll and an ocx file

    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.

  12. #12
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: unregister a dll and an ocx file

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •