Page 1 of 3 123 LastLast
Results 1 to 10 of 25

Thread: DownloadStudio And visual Basic in Microsoft Office 2007

  1. #1
    Join Date
    Aug 2009
    Posts
    36

    Default DownloadStudio And visual Basic in Microsoft Office 2007

    Hello,

    I had a lot of problems with DownloadStudio and it took a whole week to find out how to solve them.
    I post it here Just in case anybody or the support team is interested.
    Hope it helps somebody else.

    First of all, I should say I'm not here to tell it's a DownloadStudio bug (though it may be). I'm just explaining my experiments here, because there may be somebody else out there with the same problem. It may help him.

    a little about my situation:
    Os: windows 7
    Download studio version: 5.1.5.1 trial
    Microsoft Office 2007 without any updates.


    I noticed that after installing DownloadStudio, Visual Basic in Microsoft Access 2007 database files showed strange error messages and stoped working.
    I wasn't even able to modify the VB code of my databases. The main error messages occured on Set db = currentDb() which gave Unable to load DLL.

    I tried using DownloadStudio on 5 PC and all PCs behaved the same, giving the same error messages on the same line. I even noticed that I'm not able to declare new variables in VB anymore. As soon as I typed Dim tr as the database closed.


    To test the same situation, create a database in Microsoft Access 2007, Add a form to your database, Add a button to the form and add the following to onClick action of the button.
    ------------------------------------------------
    Dim db as Database
    dim rs as DAO.Recordset

    set db=CurrentDb
    msgbox "This is a test."
    --------------------------------------------------

    Save the form And close the database.
    Now Launch the database and open the form and click the button.
    You'll receive a message that the DLL can't be loaded and visual basic stops running.



    After a whole week on imaging what can be wrong, I created a snapshot of windows registry and system files on C drive.
    Later I installed DownloadStudio. After installing process and rebooting, I took another snapshot of registry and file system. There was several hundred deleted keys. I simply added the deleted keys to registry and everything was just fine.
    Access 2007 is behaving as it's supposed to once again.

  2. #2
    Join Date
    Sep 2009
    Posts
    2,680

    Default

    DownloadStudio requires the Microsoft Visual Studio Runtime, this is installed at the same time as DownloadStudio, this appears to be where the problem lies, the visual studio runtime installer is installing different versions of dlls that MS Access requires.

    Mezzmo Android: Install it on your tablet, smartphone, Android TV or Amazon Fire to browse and stream files from your Mezzmo library to all your devices. Full details at http://www.conceiva.com/products/mez...mo_android.asp
    Mezzmo for Kodi Add-on: Install it into Kodi to stream files from your Mezzmo library directly in Kodi. Full details at http://www.mezzmo.com/wiki/doku.php?...odi_user_guide
    Mezzmo for Roku App: Install it onto your Roku to stream files from your Mezzmo library. Full details at http://www.mezzmo.com/wiki/doku.php?...oku_user_guide
    Wiki: User Guides & Reference Manual at http://www.mezzmo.com/wiki
    Facebook: http://www.facebook.com/Mezzmo.DLNA.Server
    Twitter: https://twitter.com/conceiva_mezzmo
    Web: http://www.mezzmo.com

  3. #3
    Join Date
    Aug 2009
    Posts
    36

    Default

    Quote Originally Posted by Peter View Post
    DownloadStudio requires the Microsoft Visual Studio Runtime, this is installed at the same time as DownloadStudio, this appears to be where the problem lies, the visual studio runtime installer is installing different versions of dlls that MS Access requires.
    Thanks for your feedback. I hope you don't care answering several questions.

    1. Does DownloadStudio behave as it's supposed to now that I have imported all the deleted registry keys?
    2. How can I use DownloadStudio while Microsoft Access 2007 is installed? Now that I have tested DownloadStudio, I don't want to go back to other download managers.
    3. What's the correct way to make Microsoft Access 2007 run as it should, after installing DownloadStudio? I don't think importing several hundred deleted keys is the correct way.
    4. Will this problem be solved in future versions(5.2)?



    Million thanks
    Last edited by vip_shadow; 11-12-2009 at 05:43 PM.

  4. #4
    Join Date
    Sep 2009
    Posts
    2,680

    Default

    It is difficult to know how DownloadStudio will function after making changes to the registry. Please keep us informed if you experience any problems using DownloadStudio, I would expect the most affected area would be saving of jobs and history (this is stored in an MS Access Database file). We are investigating how to restore Access to it's correct functionality after installing DownloadStudio, it appears to be related to msado15.dll, dao360.dll and accwiz.dll, these need to be re-registered to get Access working propertly.

    Mezzmo Android: Install it on your tablet, smartphone, Android TV or Amazon Fire to browse and stream files from your Mezzmo library to all your devices. Full details at http://www.conceiva.com/products/mez...mo_android.asp
    Mezzmo for Kodi Add-on: Install it into Kodi to stream files from your Mezzmo library directly in Kodi. Full details at http://www.mezzmo.com/wiki/doku.php?...odi_user_guide
    Mezzmo for Roku App: Install it onto your Roku to stream files from your Mezzmo library. Full details at http://www.mezzmo.com/wiki/doku.php?...oku_user_guide
    Wiki: User Guides & Reference Manual at http://www.mezzmo.com/wiki
    Facebook: http://www.facebook.com/Mezzmo.DLNA.Server
    Twitter: https://twitter.com/conceiva_mezzmo
    Web: http://www.mezzmo.com

  5. #5
    Join Date
    Aug 2009
    Posts
    36

    Default

    Quote Originally Posted by Peter View Post
    Please keep us informed if you experience any problems using DownloadStudio
    Sorry, but I can't help you. My trial version will expire two days from now, and I don't think I will purchase a license in this situation.
    Up to now, I haven't tracked anything wrong with DownloadStudio. It works perfectly.

    Quote Originally Posted by Peter View Post
    it appears to be related to msado15.dll, dao360.dll and accwiz.dll, these need to be re-registered to get Access working propertly.
    The most strange part is that after installing DownloadStudio, Microsoft Access 2007 doesn't response even if you repair Office 2007, or reinstall it.

    I reformatted myPC, Installed windows 7 and then DownloadStudio. Then I installed Microsoft Office 2007.
    Even now that Access 2007 is installed fresh after DownloadStudio, it fails to run vb subroutines.

    As my last request, it would be great if you or somebody in support team track down exactly which deleted keys should be added to registry to let Access 2007 works after installing DownloadStudio.
    I added several hundred keys and am sure most of them are sitting there useless.


    thank you.

  6. #6
    Join Date
    Sep 2009
    Posts
    2,680

    Default

    We will continue to investigate the problem and post here when we find a solution.

    Mezzmo Android: Install it on your tablet, smartphone, Android TV or Amazon Fire to browse and stream files from your Mezzmo library to all your devices. Full details at http://www.conceiva.com/products/mez...mo_android.asp
    Mezzmo for Kodi Add-on: Install it into Kodi to stream files from your Mezzmo library directly in Kodi. Full details at http://www.mezzmo.com/wiki/doku.php?...odi_user_guide
    Mezzmo for Roku App: Install it onto your Roku to stream files from your Mezzmo library. Full details at http://www.mezzmo.com/wiki/doku.php?...oku_user_guide
    Wiki: User Guides & Reference Manual at http://www.mezzmo.com/wiki
    Facebook: http://www.facebook.com/Mezzmo.DLNA.Server
    Twitter: https://twitter.com/conceiva_mezzmo
    Web: http://www.mezzmo.com

  7. #7
    Join Date
    Aug 2009
    Posts
    36

    Default

    Quote Originally Posted by Peter View Post
    We will continue to investigate the problem and post here when we find a solution.
    Million thanks

  8. #8
    Join Date
    Sep 2009
    Posts
    2,680

    Default

    The problem is in the dao360.dll file, the reference that MS Access uses is lost when the Visual Studio runtime is installed, I don't know why. The reference needs to be added to MS Access via the Visual Basic 'Tools' menu:

    1. Get to the visual basic tools menu by creating a new database or opening an existing database, go to a form and in the 'design' tab there should be a 'view code' button, click 'view code' to open the Visual Basic editor.
    2. Go to the 'tools' menu and choose 'references', click on the 'Browse' button and find the DAO360.dll library (it was in C:\Program Files (x86)\Common Files\microsoft shared\DAO for me)
    3. Make sure the box next to 'Microsoft DAO 3.6 Object Library' is checked and click 'OK'

    If you return to 'design' mode now everything should work correctly.

    Mezzmo Android: Install it on your tablet, smartphone, Android TV or Amazon Fire to browse and stream files from your Mezzmo library to all your devices. Full details at http://www.conceiva.com/products/mez...mo_android.asp
    Mezzmo for Kodi Add-on: Install it into Kodi to stream files from your Mezzmo library directly in Kodi. Full details at http://www.mezzmo.com/wiki/doku.php?...odi_user_guide
    Mezzmo for Roku App: Install it onto your Roku to stream files from your Mezzmo library. Full details at http://www.mezzmo.com/wiki/doku.php?...oku_user_guide
    Wiki: User Guides & Reference Manual at http://www.mezzmo.com/wiki
    Facebook: http://www.facebook.com/Mezzmo.DLNA.Server
    Twitter: https://twitter.com/conceiva_mezzmo
    Web: http://www.mezzmo.com

  9. #9
    Join Date
    Aug 2009
    Posts
    36

    Default

    Quote Originally Posted by Peter View Post
    The problem is in the dao360.dll file, the reference that MS Access uses is lost when the Visual Studio runtime is installed, I don't know why. The reference needs to be added to MS Access via the Visual Basic 'Tools' menu:

    1. Get to the visual basic tools menu by creating a new database or opening an existing database, go to a form and in the 'design' tab there should be a 'view code' button, click 'view code' to open the Visual Basic editor.
    2. Go to the 'tools' menu and choose 'references', click on the 'Browse' button and find the DAO360.dll library (it was in C:\Program Files (x86)\Common Files\microsoft shared\DAO for me)
    3. Make sure the box next to 'Microsoft DAO 3.6 Object Library' is checked and click 'OK'

    If you return to 'design' mode now everything should work correctly.
    I'm afraid to assure you it's not the case and you are on the wrong line.
    I have several reasons for this:

    The references of an Access database, effects the file.
    I have an Access database on a shared folder on a server. All the PCs in our office use this database for their daily job. If there was something wrong with the references of this file, the whole PCs on the network that use this database should face the problem, not only my PC.

    When I install DownloadStudio on my PC, I can't run this database as I explained above. But other PCs can use this database without any problem.
    It shows that the database itself(and it's references) is OK.
    The problem is something about my PC.

    What you explained above (References in VB), depends on the file itself. If there was something wrong with the references of this file, other PCs in the network should face the same problem too.

    Moreover, the references of an Access databse doesn't concern windows registry. I mean if you change the references, your PC's registry doesn't change.
    But my problem is solved when I import the deleted registry keys. By importing several deleted keys, the references of databases on a PC doesn't change. I hope you know what I mean.


    Anyhow, though I believed your solution won't help me out, I gave it a shot and tried it.
    I re-installed windows, installed office 2007 and then DownloadStudio.
    Then I followed your steps above and tried to add DAO 3.5 library (I have DAO 3.5 not 3.6), but I received the following error:
    Name conflicts with existing module,project,or object library

    Still my PC doesn't run the database, but other PCs are using this database without any problem.


    I'll be watching this thread and am waiting for your next solution.

    thank you.



    PS:

    I thought re-registering dao350.dll or dao360.dll may help/
    By Re-registering dao360.dll nothing changed. Still the same error with Microsoft Access.
    Trying re-registering dao350.dll returned the following error message during registering dll file:
    The module "C:\Program Files\Common Files\microsoft shared\DAO\dao350.dll" was loaded but the call to DLLRegisterServer failed with error code 0x8002801c.
    For more information about this problem, search online using the error code as a search term"
    Last edited by vip_shadow; 11-18-2009 at 10:09 AM.

  10. #10
    Join Date
    Sep 2009
    Posts
    2,680

    Default

    I got the same error "Name conflicts with existing module,project,or object library" the first time I added the reference, when I did it a second time it worked successfully.

    The references enabled for an Access database are specific to the file, as you state, but if a reference does not exist on a PC then the reference cannot be enabled and you get the problem "error in loading dll".

    If the reference is not in the list, because the registry entry has been removed, then it cannot be enabled until it is added to the list.

    I tried previously re-registering dao360.dll using regsvr32.exe but it didn't make a difference. The ACWZMAIN.ACCDE that operates the wizards depends upon dao360.dll to function but if it is not in the references list it cannot find it. After adding dao360.dll to the references list (twice, as the first time gets the error you mentioned) then the Access wizard works correctly.

    Mezzmo Android: Install it on your tablet, smartphone, Android TV or Amazon Fire to browse and stream files from your Mezzmo library to all your devices. Full details at http://www.conceiva.com/products/mez...mo_android.asp
    Mezzmo for Kodi Add-on: Install it into Kodi to stream files from your Mezzmo library directly in Kodi. Full details at http://www.mezzmo.com/wiki/doku.php?...odi_user_guide
    Mezzmo for Roku App: Install it onto your Roku to stream files from your Mezzmo library. Full details at http://www.mezzmo.com/wiki/doku.php?...oku_user_guide
    Wiki: User Guides & Reference Manual at http://www.mezzmo.com/wiki
    Facebook: http://www.facebook.com/Mezzmo.DLNA.Server
    Twitter: https://twitter.com/conceiva_mezzmo
    Web: http://www.mezzmo.com

Tags for this Thread

Bookmarks

Posting Permissions

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