Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 23rd, 2005, 08:07 AM
Friend of Wrox
Join Date: Mar 2005
Posts: 264
Thanks: 0
Thanked 0 Times in 0 Posts
Default problem running ms access application

well i got a simple ms access application and when ever i try to run it in ms access 2000 i get this error :
Microsoft Visual Basic
Compile error:

Can not find project or library.

It workes well in my friend pc . When i look at refrences i see some missing libraries! (MISSING:Microsoft DataGrid Control 6.0(OLEDB))could any one help me how to fix this .Thanks

Old March 23rd, 2005, 09:16 AM
Friend of Wrox
Join Date: Nov 2004
Posts: 248
Thanks: 0
Thanked 1 Time in 1 Post

Method, I just have to ask, how much effort did you put into trying to solve this problem without asking someone else?

I'm going to try to teach you to fish. Then I'll give you the fish. But you'll have to cook it yourself.

Go out to http://search.microsoft.com

Enter the search words: missing reference access

You will find an abundance of articles. One of them is:


That one says to uncheck the reference. This is a fine solution. But if you need that reference for your Access application to work, that solution isn't right for you.

Basically, the solution to this problem is to discover the library name. Unfortunately, the References dialog doesn't always allow you to do that. (If the file name is down a long path, you can't see the name of the DLL/OCX that is missing.)

So here's the fish:

And so once again you visit search.microsoft.com and you enter the words "DataGrid Control". In the results you can discover that the data grid control is named: MSADODC.ocx.

Now you search your hard disk to see if you have such a file. If not, you're SOL (Shi* Out of Luck). You will need to find a different control to display a data grid. (There are other solutions. But they involve licensing issues that I won't go into now.)

If you can find the file, you have two choices:
1) Use the References Dialog in Access to point to the file in that location.
2) Register the control.

You can register the control by executing the DOS command:

regsvr32 "file_name_including_full_path"

Access first checks for references in the actual location specified. If not found there, it searches (among other places) the folder where your Access file resides and the registry.

Mehtod, it would be really great if you'd try a little fishing on your own. Some of the problems you're asking about have already been solved and solutions have been provided by others.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem running Application on network hellian Apache Tomcat 1 June 7th, 2007 11:44 PM
MS Data Grid control in ms access application roshla_p Access VBA 5 October 16th, 2006 02:37 AM
Other application in MS Access anukagni Access 3 May 10th, 2006 12:55 AM
MS Access Application Startup arnniema Access 6 September 2nd, 2005 10:39 AM
problem in running first web application ankit_29882 JSP Basics 2 February 11th, 2004 08:04 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.