Make ACCDE problem in Access 2007

[julietbrown]

Looking ahead, I decided to try splitting my db and compiling the front end. So I tried it on a copy of my current db.

I managed to split the db successfully, but then I wanted to compile the front end. Access refused to do it. The 'help' said it was probably because the db is "too big", but this seems wildly unlikely to me. I have about 40 queries, 40 forms and 30 reports, whereas 'help' is talking about thousands???

Any ideas as to what else may be wrong that isn't allowing me to do the compilation?

[julietbrown]

Reply from myself ... which should include some very rude words directed at myself but I'd better not use them.

Anyway, I'm a prat, because there are errors in my code so it won't compile ... However, as usual the Make ACCDE 'help' was stunningly unhelpful. It should have said "The most likely reason for failing to create the ACCDE is that there are errors in your code" ... not all that stuff about huge databases!!!

Sorry, sorry, grovel

[NeoPa]

No worries Juliet. You'd be surprised at how often we make similar mistakes, and the error messages can be spectacularly unhelpful as you say.

The following snippet may give you some useful tips to help avoid some of the more easily avoidable problems in future ;)

1. Ensure you have Option Explicit set (See Require Variable Declaration).
2. Try to compile it.

Not much of a list i suppose, but I stripped out all the stuff that wasn't relevant in this case. I hope it's some help anyway.