My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Error in loading DLL
|
|
 Jun 9 2010, 05:05 PM
Post
#1
|
|
|
UtterAccess Enthusiast Posts: 53 From: Alaska  |
Hi All,
I have a tiny and super simple application running on an HP laptop for a local charity. This laptop's installation of Access has never been stable. See this thread. I have just encountered two problems, perhaps related to Access's installation. I've posted the two problems on different threads, in case they are not related. The other problem is here. This problem: I installed a new version of the application on the client laptop. Ran thru it to check it and got the compile error: "Error in loading DLL" on the CurrentDb in this code: CODE Private Sub cmdOK_Click() On Error GoTo Err_cmdOK_Click Dim dbs As Database Dim qdf As QueryDef Dim strSQL As String DoCmd.DeleteObject acTable, "tmpMailingList" Set dbs = CurrentDb Set qdf = dbs.QueryDefs![qryRpt-CCMailingList] qdf.Parameters("Characteristic") = cboCharacteristic qdf.Execute Curiously I have identical code (in fact I had just cut and pasted it) in another module and it continued to run perfectly until I imported the entire application into a new database as described in the other problem linked to above. I looked into my references, saw that the Microsoft DAO 3.6 Object Library was not checked. Checked it and got the same error message: Error in loading DLL. The check disappeared. I'm assuming that the DAO object library is corrupted and I will try coping the file I have on my machine over to this one. But if someone actually knows what's going on, especially, if all these problems are related, I'd greatly appreciate some help. Thanks, Russell |
 |
 
|
|
Jun 11 2010, 12:46 PM
Post
#2
|
|
|
New Member Posts: 12 From: Redmond, WA |
Yes, by default, ADO is checked and not DAO. Make sure DAO is checked and uncheck ADO or the database will be confused.
|
|
|
|
|
Dec 2 2010, 07:12 AM
Post
#3
|
|
|
New Member Posts: 2 |
I'm getting this error message on a fresh installation of Access 2010 64-bit. I suspect this has nothing to do with your Access installation, and nothing to do with ADO. I might post another reply when I find out what the problem is in my case... Could be a compile issue with a VBA module that contains a Declare statement...
|
|
|
|
|
Dec 2 2010, 03:00 PM
Post
#4
|
|
|
New Member Posts: 2 |
I tried this on Access 2010 64-bit and got the above error message. On Access 2010 32-bit, I got a different error message when I tried to do exactly the same thing - include a Reference for DAO 3.6
http://social.answers.microsoft.com/Forums...fd-8cac028b3da6 SNIP..."...Access 2007...it seems you don't need "Microsoft DAO 3.6 Object Library" since "Microsoft Office 12.0 Access Database engine Object"does the job. When I try to add the reference "Microsoft DAO 3.6 Object Library", I get the error you mentioned."...SNIP More information can be found at: http://www.mrexcel.com/forum/showthread.php?t=480158 I'm still not sure I've completely resolved the problems I'm having with References - I might post here again if I find anything else. This might help though. |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 26th May 2013 - 02:38 AM |
Tag cloud:
access 2007 reference library error in loading dll, access vba reference error in loading dll excel 12.0 object library, Error in loading DLL office 2013, access error loading dll, error loading dll in access 2007 adp, microsoft dao 3.6 object library error in loading dll, error in loading dll access 2010, microsoft access 2010 error in loading dll, error in loading dll access 2007, error loading dll access, access error in loading dll 2010, error loading in dll access, access 2010 error loading dll, microsoft dao 3.6 object library error loading dll, how to reference word 2010 dll in access 2010