Can't make MDE file

[Wayne West]

I've had an MDB that I've been working with for over a month. It's a
reporting system against a SQL Server, so all it has are table links,
queries, reports, and a handful of forms. I've been converting the file to
an MDE then copying it to the user's shared area and haven't had a
problem.... until today.

I don't know what's happening, but when I try to make it into an MDE, the
status bar displays "Make MDE/ADE" and Access stops responding. I'm running
Office Pro 2003 with SP3.

I thought something in the internal structure might have gotten squirreled
up, so I created a blank MDB and imported all of the objects into it, but I'm
getting the same results. Also, a system reboot did nothing to change the
situation.

Any suggestions?

 

[Wayne West]

A few more points. Most of the work is taking place on SQL Server: with the
exception of a couple of crosstabs, Access isn't doing much. (My SQL Server
is 2000, so I can't do the crosstabs there as easily). The file size is
usually about a megabyte, so it's fairly small. All of the linked tables
connect to views that handle all of my field and selection criteria.

 

[Albert D. Kallal]

The usual culprit in this case is that there is some compile error in your
code.

while in the code editor simply do a debug-->compile from the menu.....

T try doing a compact and repair also. if the above to approaches don't fix
this problem, then you likely got some kind of corruption or damage to the
file. by would consider making a blank . Database, and then try importing
all the old stuff into it....

 

[Wayne West]

Very odd. I did the compile and got no errors. I always do a compact before
making it into an MDE, and this time the make completed.

Very odd. No compile error, but still, something got a little screwy.
Still, it's once again an MDE, and that's all I care about.