Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old January 29th, 2005, 07:32 AM
Authorized User
 
Join Date: Mar 2004
Location: Watford, , United Kingdom.
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default error in loading DLL in Access 2003

I have an ADP that runs fine in Access XP but in Access 2003 this statement:
    currentproject.accessconnection
produces this error:
    error in loading DLL

Does anyone know which DLL contains the code for this statement? Better yet, when Access produces really unhelpful error messages like this is there any way to find out exactly what the problem is?

I have tried running the Office repair process. I want to avoid reinstalling Office 2003 if possible (because I will lose all my customizations) but if it is the only way then so be it.

PS I am really annoyed that the error message does not say which DLL it cannot load - this seems incredibly lazy coding.

R
__________________
R
Reply With Quote
  #2 (permalink)  
Old January 30th, 2005, 10:09 AM
Friend of Wrox
 
Join Date: Nov 2003
Location: Lehigh Acres, FL, USA.
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

Try looking the visual editor tools, reference and check for missing library or dlls

Jaime E. Maccou
Reply With Quote
  #3 (permalink)  
Old January 31st, 2005, 08:06 AM
Authorized User
 
Join Date: Mar 2004
Location: Watford, , United Kingdom.
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

All the references that should be there, are there. I know this for sure because THE VERY SAME ADP file runs under Access XP but not under Access 2003.

To be clear:
The ADP file and the SQL database reside on machine A
Access 2003 is on machine A
Access XP is on machine B

When Access 2003 runs the ADP it gets the "error in loading DLL" message, but Access XP runs the very same ADP (not an identical copy, the very same file) okay.

So clearly on machine A there is either a missing or faulty DLL. I just need to know WHICH DLL is missing/faulty?

FYI
These are the references that are ticked:
VB** VBA
MSACC.OLB Microsoft Access 10.0 Object Library
STDOLE2.TLB OLE Automation
MSADO26.TLB Microsoft ActiveX Data Objects 2.6 Library
SQLDMC** Microsoft SQLDMO Object Library
MSCOMCT2.OCX Microsoft Windows Common Controls-2 6.0 (SP4)

(** these locations are so long that not all the filename can be seen)

R
Reply With Quote
  #4 (permalink)  
Old February 1st, 2005, 06:27 AM
Authorized User
 
Join Date: Mar 2004
Location: Watford, , United Kingdom.
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Is there no way of working out which DLL the message "error in loading DLL" is referring to?

Is there no way of working out which DLL the statement "currentproject.accessconnection" resides in?


R
Reply With Quote
  #5 (permalink)  
Old April 25th, 2006, 03:48 PM
Registered User
 
Join Date: Apr 2006
Location: Leeds, , United Kingdom.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Richard,

Did you ever figure out how this problem occurred, or even how to fix it? I'm currently having the same problem with a database I have exported.

Cheers

Jon

Jon Satchwell
Reply With Quote
  #6 (permalink)  
Old April 25th, 2006, 09:35 PM
Friend of Wrox
 
Join Date: Mar 2004
Location: Yorba Linda, California, USA.
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post
Default

Richard,
I had a similiar problem except with an .mdb. The file, which resides on a share file on a server, ran fine on my co-workers machine. But I got "error 48- missing dll" on a GetObject function call in an button click event from my machine.

The bottom line was the file ran fine AFTER re-installing Access (2K) AND the OS.

HTH,
Loralee

Reply With Quote
  #7 (permalink)  
Old August 14th, 2006, 05:16 PM
Registered User
 
Join Date: Aug 2006
Location: , , United Kingdom.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have a similar problem in that I get the 'error in loading dll' message when going to entering the vb editor. Consequently none of the code runs correctly.

The references from the 'Tools' menu say that MSo9.dll is missing (which it isn't) but doesn't allow it to be unchecked and closed then restoring it as suggested by MSDN Knowledge base as a method of refreshing the references. The dll is exactly where is should be in the path shown on the references screen.

Now the puzzling thing is that it is a copy database that has had data entered into it only from Access 2003 users (developed on Access 2000 pc). They have not modified the database in any other way.

The original copy database loads fine!

There is nothing peculiar about the database, only default dlls apart from the DAO library.

The only solution I can think of is to copy the tables over to the original database. I would rather have an explanation.



Reply With Quote
  #8 (permalink)  
Old February 27th, 2012, 01:59 PM
Friend of Wrox
Points: 952, Level: 12
Points: 952, Level: 12 Points: 952, Level: 12 Points: 952, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2010
Posts: 227
Thanks: 5
Thanked 24 Times in 23 Posts
Default

Quote:
Originally Posted by Richard Lally View Post
All the references that should be there, are there. I know this for sure because THE VERY SAME ADP file runs under Access XP but not under Access 2003.
That only means that you have the correct references for Access 2002 (XP) with the same version of ADO/MDAC. That does not mean the reference will be correct for a machine with Access 2003.

My first thought is that the ADO/MDAC libraries are not the same version.
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft MVP - Access Expert
Reply With Quote
  #9 (permalink)  
Old March 5th, 2012, 07:42 PM
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This problem occured in many different files after an overdue migration from 2000 to 2003, for 3 different MDB files originally created in Access 2000. I experienced something similar when opening in Access 2007 and 2010 but the fix was literally just re-enabling the references via Tools menu in the VB Editor.

If you upgraded from Office 2000 to 2003, this was the mskb that resolved the issue for me at least. Might be worth trying. http://support.microsoft.com/kb/899861

Regards,
Jason Shinkle
jason@tecktronic.net

Last edited by jason412; March 5th, 2012 at 07:45 PM.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access without loading? tal Javascript 1 July 2nd, 2007 02:55 PM
How can I build a ActiveX DLL in VS.net 2003 ? Mohammed ASP.NET 1.0 and 1.1 Basics 13 July 13th, 2006 11:47 AM
Problem while loading oci.dll nvenkat75 .NET Web Services 0 January 21st, 2006 08:31 AM
Customizing MS OFFICE 2003 using SINGLE DLL..? pradpb999 Access 1 December 27th, 2005 12:37 PM
Chap 6 Beg ASP? re: loading .dll on server bhaub Classic ASP Basics 3 August 17th, 2004 12:31 AM



All times are GMT -4. The time now is 05:27 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.