DownloadStudio And visual Basic in Microsoft Office 2007

[vip_shadow]

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.

no matter how many times I try, still the same error message. No improvement.

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 a reference doesn't exist on a PC and an Access database is set to use it, it starts with a **MISSING** in references lists and the VB code doesn't run without any error message (At least in my case it is how it works).
Create a database on a PC with office 2007 installed, and add Microsoft Excel 12.0 Object library reference.
Now if you move this database to a PC with Office 2003 installed, you'll have a **MISSING**Microsoft Excel 12.0 Object library in your references list.
I haven't any reference starting with Missing in my list.

Anyhow, I tried more than 10 times to add dao reference, but it still shows the conflict error message. I believe it's because of the difference between DAO dlls of Microsoft Visual Basic 2005 and Microsoft Access.

Do you have any idea how I can un-register the DAO installed by Visual Basic 2005 and re-register DAO of Access 2007?

Many thanks.

[Peter]

I could reproduce the error message, "Name conflicts with existing module, project or object library", by checking the box next to Microsoft DAO 3.6 Object Library. This library is not compatible with "Microsoft Office 12.0 Access database engine Object Library", so if you have them both enabled dao360.dll will not be successfully registered when you click 'OK'. If you try unchecking the box next to "Microsoft Office 12.0 Access database engine Object Library", then browse and add dao360.dll, then click 'OK'. Open Tools->References again and re-check "Microsoft Office 12.0 Access database engine Object Library" and uncheck Microsoft DAO 3.6 Object Library.

To confirm this fix I uninstalled DownloadStudio, then re-installed DownloadStudio and got the same error appearing "error in loading dll". I opened the Tools->References in Visual Basic and unchecked "Microsoft Office 12.0 Access database engine Object Library", clicked 'Browse' and located dao360.dll, clicked 'Open' and then 'Ok' to close the references dialog. Then I re-opened references, unchecked Microsoft DAO 3.6 Object Library and re-checked "Microsoft Office 12.0 Access database engine Object Library" and everything worked correctly.

[vip_shadow]

To confirm this fix I uninstalled DownloadStudio, then re-installed DownloadStudio and got the same error appearing "error in loading dll". I opened the Tools->References in Visual Basic and unchecked "Microsoft Office 12.0 Access database engine Object Library", clicked 'Browse' and located dao360.dll, clicked 'Open' and then 'Ok' to close the references dialog. Then I re-opened references, unchecked Microsoft DAO 3.6 Object Library and re-checked "Microsoft Office 12.0 Access database engine Object Library" and everything worked correctly.

Sorry, but here the case seems to be different.
this is what I did:
I uninstalled Download Studio and Re-installed it again. I received the same error in loading dll
I unchecked Microsoft Office 12.0 Access database engine Object Library
Then I Browsed for DAO360 (C:\Program Files\Common Files\Microsoft Shared\DAO\) and Open and then OK.
After All I unchecked Microsoft DAO 3.6 Object Library and re-checked "Microsoft Office 12.0 Access database engine Object Library"

Still the same "Error In Loading DLL" insists.

[Peter]

I tried it a few more times by unregistering dao360.dll using regsvr32.dll and then adding the reference to Visual Basic and on one attempt it did fail to add the Microsoft DAO 3.6 Object Library even after I Browsed for dao360.dll and clicked Open and OK. I got around this by leaving Microsoft DAO 3.6 checked and returning to the Access Design view and adding a button, then I returned to references and unchecked the Microsoft DAO 3.6 Object Library reference. Could you please try this?

Also, is Microsoft DAO 3.6 Object Library appearing in your references list after you get the "Error in loading DLL"? If it is not there then the above procedure should work.

[vip_shadow]

I tried it a few more times by unregistering dao360.dll using regsvr32.dll and then adding the reference to Visual Basic and on one attempt it did fail to add the Microsoft DAO 3.6 Object Library even after I Browsed for dao360.dll and clicked Open and OK. I got around this by leaving Microsoft DAO 3.6 checked and returning to the Access Design view and adding a button, then I returned to references and unchecked the Microsoft DAO 3.6 Object Library reference. Could you please try this?

Also, is Microsoft DAO 3.6 Object Library appearing in your references list after you get the "Error in loading DLL"? If it is not there then the above procedure should work.

I did what you asked.
I uninstalled Download Studio and Re-installed it again. I received the same error in loading dll
I unchecked Microsoft Office 12.0 Access database engine Object Library
Then I Browsed for DAO360 (C:\Program Files\Common Files\Microsoft Shared\DAO\) and Open and then OK.
I added a button to a form and then I unchecked Microsoft DAO 3.6 Object Library and re-checked "Microsoft Office 12.0 Access database engine Object Library"

Hurray..... Access 2007 is on the mood and works perfectly.

But too soon to be happy. Only this database works. the other databases doesn't work and show the same error message.
I have to change the references of each database one by one (and adding a button to a form) to make them working.
Too frustrating.

-------------------------------------------------------------------------
I found a better way to let Microsoft Access 2007 work as it should while I have DownloadStudio installed.

this is my steps:

1. I created a system restore point through control panel's System and security
2. Installed DownloadStudio.
3. Copied the whole DownloadStudio folder in Program Files and Start Menu to an external drive.
4. Restored my system to the point I had created in step 1.
5. copied back DownloadStudio's folder from external drive to Program Files and Start Menu folder.

At this point both Access and downloadStudio work perfectly.
The only problem that remains is DownloadStudio's extension in firefox doesn't respond.
To solve this problem, I installed FlashGot extension.
and in flashgot's options (General Tab) I clicked Add button, typed New DownloadStudio and browsed for the folder I copied back to Program Files above.

wooow, everything's fine. I'm able to use DownloadStudio from firefox and Access 2007 is perfect.

But ....... wait ....... the only thing remains is how to download videos?

I don't care about this remaining little problem. because:

1. I rarely download movies
2. If I need to download a movie, I run DownloadStudio's sniffer and ... you know the rest.

God knows how many hours I spent to be able to use DownloadStudio.




My last word if you're interested.
I don't believe the Error in loading dll error is because of installing Microsoft Visual Basic 2005 during installation of DownloadStudio.
I have been using other softwares that install Microsoft Visual Basic 2005 before and never access had shown this error on my system before.
I believe there should be something wrong with DownloadStudio's package that causes this problem.

if you want to try it do as what I did last night.
I installed microsoft Office 2007 on a clean system, and then installed Microsoft Visual Basic 2005.
All of my applications in Access 2007 run smoothly without showing a single error.

[Peter]

After I have added the reference 'Microsoft DAO 3.6 Object Library' to the list in one database it remains in the list and each database I open works correctly. I don't have to add it for each database.

DownloadStudio's firefox extension relies on the registry entries created by the DownloadStudio installer, if these registry entries are removed by the system restore then the firefox extension cannot locate the DownloadStudio.exe.

YouTube and DailyMotion have changed their site slightly, so DownloadStudio cannot currently download videos by pasting the URL, this will be fixed in DownloadStudio 5.2.

The 'Error in loading' dll is caused by dao360.dll being unregistered, I can reproduce this behaviour by running "regsvr32.exe /u C:\Program Files (x86)\Common Files\microsoft shared\DAO\dao360.dll", the DownloadStudio InstallShield is unregistering this dll for some reason (we are investigating this).

To make it easier to repair the 'Microsoft DAO 3.6 Object Library' for all programs and databases, add the following to a text file and name it 'dao.reg':

REGEDIT4

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\TypeLib\{00025 E01-0000-0000-C000-000000000046}]

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\TypeLib\{00025 E01-0000-0000-C000-000000000046}\5.0]
@="Microsoft DAO 3.6 Object Library"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\TypeLib\{00025 E01-0000-0000-C000-000000000046}\5.0\0]

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\TypeLib\{00025 E01-0000-0000-C000-000000000046}\5.0\0\win32]
@="C:\\Program Files (x86)\\Common Files\\microsoft shared\\DAO\\dao360.dll"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\TypeLib\{00025 E01-0000-0000-C000-000000000046}\5.0\FLAGS]
@="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\TypeLib\{00025 E01-0000-0000-C000-000000000046}\5.0\HELPDIR]
@="C:\\Program Files (x86)\\Common Files\\microsoft shared\\DAO"


Save the text file and double click it to restore the dao360.dll registry settings.

[vip_shadow]

To make it easier to repair the 'Microsoft DAO 3.6 Object Library' for all programs and databases, add the following to a text file and name it 'dao.reg':

REGEDIT4

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\TypeLib\{00025 E01-0000-0000-C000-000000000046}]

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\TypeLib\{00025 E01-0000-0000-C000-000000000046}\5.0]
@="Microsoft DAO 3.6 Object Library"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\TypeLib\{00025 E01-0000-0000-C000-000000000046}\5.0\0]

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\TypeLib\{00025 E01-0000-0000-C000-000000000046}\5.0\0\win32]
@="C:\\Program Files (x86)\\Common Files\\microsoft shared\\DAO\\dao360.dll"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\TypeLib\{00025 E01-0000-0000-C000-000000000046}\5.0\FLAGS]
@="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\TypeLib\{00025 E01-0000-0000-C000-000000000046}\5.0\HELPDIR]
@="C:\\Program Files (x86)\\Common Files\\microsoft shared\\DAO"


Save the text file and double click it to restore the dao360.dll registry settings.

I'm out of my trial period and I couldn't test it myself. Anyhow, I could make a friend accept to download and test DownloadStudio.
the above method didn't work out. We are still receiving the Error in loading DLL error.

[Peter]

If your friend runs regedit, are they able to see any of the registered keys? For example, is "HKEY_LOCAL_MACHINE\SOFTWARE\Classes\TypeLib\{0002 5 E01-0000-0000-C000-000000000046}\5.0" present in their registry after running the script?

[vip_shadow]

the error message occurs on Set dbs = currentDb() line

[Peter]

Are you running 32bit or 64bit Windows? If you are running 64bit then the registry script should work as the path to dao360.dll is correct, if you are running 32bit then you will need to edit the script to remove the " (x86)" from the path:

REGEDIT4

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\TypeLib\{00025 E01-0000-0000-C000-000000000046}]

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\TypeLib\{00025 E01-0000-0000-C000-000000000046}\5.0]
@="Microsoft DAO 3.6 Object Library"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\TypeLib\{00025 E01-0000-0000-C000-000000000046}\5.0\0]

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\TypeLib\{00025 E01-0000-0000-C000-000000000046}\5.0\0\win32]
@="C:\\Program Files (x86)\\Common Files\\microsoft shared\\DAO\\dao360.dll"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\TypeLib\{00025 E01-0000-0000-C000-000000000046}\5.0\FLAGS]
@="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\TypeLib\{00025 E01-0000-0000-C000-000000000046}\5.0\HELPDIR]
@="C:\\Program Files (x86)\\Common Files\\microsoft shared\\DAO"

does dao360.dll exist in the same location on your computer as in the script?
C:\Program Files (x86)\Common Files\microsoft shared\DAO\dao360.dll
or is it
C:\Program Files\Common Files\microsoft shared\DAO\dao360.dll