Ms Access Currentdb Error In Loading Dll
Contents |
360 games PC games error in loading dll excel Windows games Windows phone games Entertainment All Entertainment error loading dll access 2010 Movies & TV Music Business & Education Business Students & educators runtime error 48 error in loading dll Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet
Error In Loading Dll Microsoft Dao 3.6 Object Library
Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All error in loading dll excel 2013 Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 20 Oct 2016 19:22:58 GMT by s_wx1206 (squid/3.5.20)
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about http://stackoverflow.com/questions/9744024/how-to-correct-for-inability-to-load-dao-dll-in-access-2003-on-windows-7 hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. http://forum.conceiva.com/archive/index.php/t-389.html Join them; it only takes a minute: Sign up How to correct for inability to load DAO DLL in Access 2003 on Windows 7? up vote 2 down vote favorite 1 I have an application that uses the MS loading dll Access 2003 front end to connect to both a MS SQL and a Sybase database. This application uses VBA (Visual Basic 6) and this cannot be changed. We are in the midst of a conversion from Windows XP (where the application runs fine) to Windows 7. On Windows 7, attempts to connect to the Sybase databsae fail. The application uses a pass through query and when the failure occurs, I receive the following message: An unexpected error occurred error in loading in Call_SP. Error number: 48 Error description: Error in loading DLL Error source: Secure open security The particular line of code where this is throwing the error is: For Each qryDef In dbLocal.QueryDefs The items in this line of code are defined like this: Dim dbLocal As Database Dim qryDef As QueryDef Set dbLocal = CurrentDb() When originally launching the application, there was a missing reference for Microsoft DAO 3.6 Object Library. I copied the dao360.dll file to C:\Program Files (x86)\Common Files\Microsoft Shared\DAO, registered it using regsvr32.exe, and set the reference (Tools -> References) to this file. At this point, I suspect the problem may have something to do with user rights on this machine, but I'm stuck on where to start. Users do have "read and execute" rights on the dao360.dll file. We have a lot of legacy apps written in Access, so our systems use Access 2003, but Word, Excel, and Outlook 2010. We are moving to Windows 7 64-bit. ms-access vba windows-7 dao share|improve this question edited Mar 17 '12 at 2:12 Bob77 10.9k11530 asked Mar 16 '12 at 20:23 Timbuck 180619 1 I wonder about the missing dll, because this PC has never had anything earlier than Access 2010 yet it still has DAO 3.6 libraries. Have you tried reinstalling Access? –Fionnuala Mar 16 '12 at 21:14 VBA 6 is not Visual Basic 6. Thi
2007 vip_shadow11-11-2009, 04:22 PMHello, 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. Peter11-12-2009, 04:17 PMDownloadStudio 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_shadow11-12-2009, 05:36 PMDownloadStudio 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 inst