Database won't compile

[Guest]

I'm having trouble compiling a database to an mde file. It was working ok
until the other day right after I split the database into a front end and
back end on our server. Would this cause a problem for the database to not
compile? It sits there with the status bar saying that it is compiling but
never finishes and I wind up cancelling out of the whole thing with task
manager.

Thanks in advance,

 

[Guest]

Hi,
did you try to compile your code individually? Open any module in the VBA
editor and then compile through there...make sure you compile ALL your code.
If errors come up then fix them there. Then retry to create your mde.
HTH
Good luck

 

[Guest]

Sorry freak, it doesn't work that way. If you compile any module in an
Access database, it compiles all the code in the database, so doing compiles
on individual modules is of no vaule.

It may be that the database has corruption problems. I would suggest, as a
first step, a decompile. It has it's risks, but can be valueable. Here is a
site that explains it:

http://www.granite.ab.ca/access/decompile.htm

 

[Guest]

You might have to do a decompile first to clean things up. Here's a link on
how to do it:
http://www.granite.ab.ca/access/decompile.htm

 

[John Nurick]

AIUI this is true of Access 2000 onwards, but not of earlier versions.
Or is it subtler than that?