Compile Error

[tpoettker]

I have a unusual problem (or it seems to me). I created a database in MS Access. I imported a table, form and report from another database. I have VBA code behind the form. I added the following references:

Visual Basic for Applications
Microsoft Access 8.0 Object Library
Microsoft DAO 3.51 Object Library
Microsoft ADO Ext. 2.6 for DDL and Security
Microsoft Jet and Replication Objects 2.6 Library
Microsoft ActiveX Data Objects 2.1 Library

I run the application over the network with no problem. I have a second laptop that is connected to the network. I run the application on that laptop with no problem. I have a co-worker that tries to run the application and receives the "Compile Error: Can't find project or library" error. How come?

Thanks

Tina Poettker

 

[LeeJames75]

Ok let me get this straight.

1 You developed on a Networked PC.
2 Your Laptop was connected to the Network at the Time.

3 Your co-worker was or was not connected to the Network ??

Possible answers. Your Database Administrators may have only setup your MS Access files so only your profile or the Network profiles can access this database.

It is a form of Software Dongel. Alot of big firms implement this, so staff don't copy programs and take them home.

If your co-worker isn't connected to the network then they won't be able to communicate with the packet to identify itself.

Another answer maybe that you have not not changed the settings in your access database to allow other users.

Just a few thoughts.

Regards

Lee James
NHS Data Analyst
England

 

[tpoettker]

My co-worker was connected to the network and the database is setup for any user.

 

[LeeJames75]

Have you tried re-installing MS Access on your co-workers screen. Or ran the compact and repair.

Otherwise, I'd check with your network administrators to see what priviledges your co-worker has to the directory the database is stored on.

 

[willir]

Tina

Does your buddy have the same plug-ins as you??

A real common problem, especially with Microsoft's focus on moving away from DAO is to not add it in the reference library in the default install.

You stated you have....
Visual Basic for Applications
Microsoft Access 8.0 Object Library
Microsoft DAO 3.51 Object Library
Microsoft ADO Ext. 2.6 for DDL and Security
Microsoft Jet and Replication Objects 2.6 Library
Microsoft ActiveX Data Objects 2.1 Library

Does the rogue laptop also have the same, especially DAO.

Another compatability problem is the version of MDAC.

Richard

 

[pdldavis]

I'd have to agree with the last post. I've run into several issues where I use Outlook 10 object or the Access Chart object library running Windows XP, Office 2002, for example. Someone else may be running Windows 2000 and Outlook 9 object library, hence the "Compile Error: Can't find project or library"

You might go to Tools / References on the computer in question and do a comparison.

 

[jksmi]

Hi,

Also in agreement with Willir - I've had problems with co-workers' machines that have had exactly the same build as mine but havent had some libraries registered properly (they exist on the machine but weren't registered!?). Have a search for registering libraries in tek-tips - I've definitely seen stuff on here before that describe how you can remove a broken link and re-reference a library by its guid (works if they have an older version than you, i.e. Microsoft Jet and Replication Objects 2.6 Library is newer than the standard A2K version) or you can use regsvr32 to register libraries that just werent registered properly...

HTH, Jamie
FAQ219-2884