Database won't compile

  • Thread starter Thread starter Guest
  • Start date Start date
G

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,
 
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
 
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
 
AIUI this is true of Access 2000 onwards, but not of earlier versions.
Or is it subtler than that?
 
Back
Top