?
Solved

compile error

Posted on 2011-02-16
5
Medium Priority
?
272 Views
Last Modified: 2012-05-11
i converted a database from 2003 format to 2007, when i try to run a vba code i get this message: 'Compile error: User-defined type not defined'
can someone help me with that?
0
Comment
Question by:yoily
5 Comments
 
LVL 14

Expert Comment

by:svgmuc
ID: 34907120
If you provide the code that causes the error...
0
 
LVL 85
ID: 34907196
After converting, check the References to insure they converted correctly. To do that, open the VBA Editor and click Tools - References. Are any marked as MISSING?

If so, then do this:

1) Note the name and location of the Reference
2) Uncheck the reference
3) Close and reopen the Reference dialog
4) Locate and re-check the reference

If none are marked as MISSING, then do this:

1) Open the Reference dialog
2) Uncheck any reference. Make sure to note the name and location of that reference first
3) Close and reopen the reference dialog
4) Locate and re-check the reference.

Also, BEFORE you convert you database, you should do Compile your application. To do that;

1) Open the VBA Editor
2) Click Debug - Compile. Fix any errors, and continue doing this until the menuitem is disabled
3) Now Compact your database (Tools - Database Utilities - Compact)

Now try converting the database.

Of course, before doing any of this, be sure to make a Backup of your database.

Note too that Access 2007/2010 seems to be much more choosy (and far less forgiving) in regard to VBA code. If, after doing all this, you still find errors, then you'll need to do as svgmuc suggests and locate the code that throws the error and post it here.

0
 

Author Comment

by:yoily
ID: 34907270
0
 
LVL 31

Expert Comment

by:Helen Feddema
ID: 34907667
It appears that you don't have a reference set to whatever object library QBSessionManager belongs to.  Can you check the references in Access 2003?
0
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 34908361
That's a QuickBooks related item. Does your application interact with Quickbooks? If so, have you installed the necessary files on your machine (i.e. the SDK, or the Merge files)?
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question