[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 704
  • Last Modified:

Cannot create ACCDE out of Access 2010 DB

I have just finished a database for distribution and cannot publish it as an ACCDE.  MS is returning an unhelpful error which has details stating that the DB "might" have too many objects, tables, etc.  The DB has 2 tables, a few queries, and not a lot of VB.  It does not link to another library.

Can someone possibly take a look at it and tell me where I am going wrong and what I can do to make it work?
CRITERION-LOOT.accdb
0
Hobart007
Asked:
Hobart007
  • 3
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Your ACCDB has multiple Compile errors. You will not be able to create an ACCDE until *all* compile errors are fixed.   One of many examples is below - see screen shot.

mx
Capture1.gif
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Opps sorry wrong screen shot ...

see below
Capture1.gif
0
 
Hobart007Author Commented:
Wow.  Thanks.  So I just ran the compile database command and remove the offending errors and it worked.  I guess I should remove unnecessary code from a form if I am going to copy and paste it.

Thank you!
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Yep ... must do so.  Good to hit the Compile button often during development.

mx
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now