Two years of work and can't compile - help!

[patbeau]

After two years of work and hundreds of dollars to MS Support, I can't
compile my database and I have customers waiting for it. I'm ready to pull
my hair and everyone's at MS as well. Can anyone help?

[Tom van Stiphout]

On Wed, 11 Nov 2009 19:25:01 -0800, patbeau
<pat...@discussions.microsoft.com> wrote:

Is this the first time after two years of work that you compile your
database? That seems hard to believe.
What EXACTLY happens when you try to compile?

-Tom.
Microsoft Access MVP

[John W. Vinson]

On Wed, 11 Nov 2009 19:25:01 -0800, patbeau
<pat...@discussions.microsoft.com> wrote:

Well, I never let two DAYS go by without compiling; in fact I'll compile after
making any changes to a sub or function!

What specific problems do you have? What error message do you get when you
select Debug... Compile?

Do you have more than the three or four basic references in Tools...
References? If so, do you need them all? Are they all consistant and up to
date?

Can you Compact the database successfully (MAKE A BACKUP FIRST!!!!!)

You may want to Decompile (since using the database will at least partially
compile it), Compact, and then try to compile. DON'T EVEN THINK about
decompiling without a good backup!

You may want to look over some of these references:

Tony Toews' Corrupt Databases FAQ:
http://www.granite.ab.ca/access/corruptmdbs.htm

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

--

John W. Vinson [MVP]

[Jeff Boyce]

Do you (just in case) have a backup copy?

Make a copy of that copy and try compiling that, if you aren't able to get
your current version to compile.

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"patbeau" <pat...@discussions.microsoft.com> wrote in message
news:6943267D-2FF5-444F...@microsoft.com...