access 2003

This was compiling with no issues.  Then a certain windows update has caused this compile issue for access 2003, but I do not know which windows update in windows 7 it is.

Are you saying it does not compile now?
Is there a Reference issue ?

mx

by the way this is not a project  just a straight mdb frontend

Project ?

Can you answer my previous questions ?

No reference issues just stops, never finishes the mde make routine internally.  If I take it to an old XP system with out the windows updates, it will complie an mde.  but  I have to search for a system to do this make mde.

this is an old Access 2003 mdb

what version of Windows 7...
There are issues with Access and Win 7 64 bit...

MX could probably go into more detail but...

Just note that Access 2003 is almost 10 year old technology.
It has long past out of "Mainstream Support" (in 2009) and no other updates will be issued.
(...so you may want to consider migrating to 2007 at a minimum...)

Perhaps this is a win 7 update issue, ...in which case you will have to hope that MS chooses to fix it in a future SP.

..or they may very well be a fix for this....


Jeff

This also happened to me a while ago.
In addition to what MX posted, I had to delete all unused:
Code, Procedures, Functions, Comments, Variables, whitespace, code library references,...etc.

To be sure, I made sure all my variables were declared and I was closing all of my recordsets, ...etc

Jeff

Running Win 7 - 32 - ent and prof.
Yes we would like to move this up to  Access 2007, unfortunately we have vendor programs that are still using Access 2003 in the productions plant and can not run them in Access 2007, so we are struck with access 2003 for the time being.

Just noting that A2007 is 5 years old, and A2010 is greatly improved over A2007.

mx

but how does this solve my issue with making an mde in 2003.  Can I make an mde in A2010 to run in A2003?

"Can I make an mde in A2010 to run in A2003?"
Definitely not.  And MDE must be created in the lowest version that will be used to run it.

I don't know what is causing your issue of hanging ... Did you run that procedure I posted ... to be sure ?

mx

I'll give it a try,  This may be something Microsoft is doing to cause problems.

running the comple in VB works just fine.  No errors

It comes back to the  A2003 Make MDE internal routine, starts and and never finishes. Just goes out to the Twilight Zone  as we call it.

Humm.  So, you ran the *full* Decompile procedure above ?

did not run the decomplie

Decompile is the crucial part ... please try that.

first ran the compact and repair with no problem,
Then Tried the decompile  the program opened fine.  then after that it then would not compact and repair just cause the mdb and access to crash

Also be sure that your Office/Access and Windows installations are fully up to date, and try rebooting before creating your .mde file. I've often had to do that after doing a LOT of work (especially if I'm working in different environments, like VBA and .NET).

OK MX,
I created a new blank Db, Imported the my forms rpts, mac, etc into the new db.
Converted it to a  2003 format.  then ran C&R.
Closed and restarted my system.  Ran the Decomplie and the db opened fine.  did a C&R and closed the DB. opened the db again and went to the VB editor and ran debug to complie.
Then  ran a C&R again, no issues.  Then tried to create an MDE and it then worked.

I also turned off a few process that were running in the Task manager,  Do not know if these had any effect on this or not?

So,  I hopefully, part of the process of decompiling, etc. help with the issues.
Thanks

MX, Helped solve the issues we were dealing with in creating and MDE in Access 2003, by pointing to the Decompile, which seamed to help.