Database won't compile

G

Glenn Suggs

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,
 
F

freakazeud

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
 
K

Klatuu

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
 
J

John Nurick

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