DownloadStudio And visual Basic in Microsoft Office 2007

[vip_shadow]

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

Million thanks

[Peter]

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.

[vip_shadow]

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"

[Peter]

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.

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

[kathyw]

I had the same issue - where I was getting error message while trying to load dao360.dll. Once I unticked the Microsoft Office 12 reference for that database all worked well. I just had one user that was having issues - but as this database was all created using DAO rather than ADO changing references has allowed all to operate the database