MDE opening failure

[RayH]

I have a database split into two parts, one for forms and the other for data which is linked (FE/BE??).
The Forms one has been compiled/converted into an MDE type.

The files are both on a network drive. The MDE is called via a shortcut from the desktop.

Firstly, are there problems with this setup, apart from loading speed?

Secondly, when the MDE is opened directly or via the shortcut Access will open, briefly display the form then close the database leaving Access open. If Access is closed either via the X or Flie,Exit a message is displayed that "MSACCESS.exe has generated errors and will be closed by Windows. You will need to restart the program. An error log is being created."

Now, if I open the same database using the same method from my PC without making any changes the DB will open fine. Then going back to the first PC and opening it again will now work.

Bear in mind that we are talking about the MDE version. The MDB version works fine at all times.

Is the MDE getting corrupted somehow?
Is the setup causing the problem?

Both PCs are Win 2k and Office 2k

Anyone?

 

[Uncle Gizmo]

Have you tried Decompiling the mdb version before making an mde out of it?

 

[RayH]

No. How would I go about that task?

 

[Uncle Gizmo]

decompile switch

This is for MS Access 2000, can't remember if its the same for A97?

Type the following in the "Run" box under the "Start" button where the 1st part is the path to your Access.exe, the second part is the path to the db you want to decompile.

This will open your db, once opened select a module or form module then >>>DeBug >>>> Decompile.

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\ATH_Work\_Current_Work\QuoteSystem2002\A2002_UPDATED_NOV_06_02\A2002S.mdb"/decompile


You should decompile your db regularly!!!

 

[RayH]

Thanks Tony

Ok, done that. The db opened I did some work, added records etc and navigated through the forms. It behaved correctly and without errors.
What should I be expecting to happen while in this mode? Error messages? Because none appear.
I am fairly confident that my code is not to blame for this scenario as it works fine with an MDB but not an MDE. Could it be something else?

 

[Uncle Gizmo]

Have you made a new mde out of the decompiled db?

 

[RayH]

I have now and its working again. I have no idea what the decompile did, if anything, maybe just the act of rebuilding the MDE made it work. But this has been done many times before, it may be just a matter of time before it will fail gain.
As I said in my original message just loading and exiting the MDB from my PC made the MDE work. I don't understand how that can be.

Thanks

 

[RayH]

I still don't get but its working and that's what counts right?