DownloadStudio And visual Basic in Microsoft Office 2007

[vip_shadow]

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.

[Peter]

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.

[vip_shadow]

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

[Peter]

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.

[vip_shadow]

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.

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.

[Peter]

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