Can't make MDE file

  • Thread starter Thread starter Wayne West
  • Start date Start date
W

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?
 
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.
 
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....
 
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.
 
Back
Top