Problem decompiling database

[Max Moor]

Hi All,
I have two database applications. Both are in Access 2002. One has
been around a few years. I decompile and recompile before each release
without issue.

The second application is relatively new, with most of its guts
imported from the older app. Everything seems okay with the new app, in that
it compiles and runs and such.

When I try to use the /decompile switch on it, I get a message that
"Microsoft Access has experienced a problem and needs to close. We're not
sorry enough for the inconvenience to give you any real information."

I might be paraphrasing a bit there at the end.

I've done a compact and repair, and have even opened a new database,
and imported everything into it. It still does it. Should I be concerned
that the database can't decompile without exploding, when it seems okay
otherwise?

Thoughts?

- Max

 

[Todos Menos [MSFT]]

yes; of course you should be concerned

MDB is not reliable; Microsoft states that it has been obsolete for 10
years
Access Data Projects are an awesome solution

-Todos

 

[Tony Toews [MVP]]

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

MDB is not reliable; Microsoft states that it has been obsolete for 10
years

Wrong.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Tony Toews [MVP]]

The second application is relatively new, with most of its guts
imported from the older app. Everything seems okay with the new app, in that
it compiles and runs and such.

When I try to use the /decompile switch on it, I get a message that
"Microsoft Access has experienced a problem and needs to close. We're not
sorry enough for the inconvenience to give you any real information."

I might be paraphrasing a bit there at the end.

I've done a compact and repair, and have even opened a new database,
and imported everything into it. It still does it. Should I be concerned
that the database can't decompile without exploding, when it seems okay
otherwise?

Interesting that the import into a new database doesn't fix the
decompile. I've heard of this but haven't encountered that myself.

Corrupt Objects within a Corrupt Microsoft Access MDB
http://www.granite.ab.ca/access/corruption/corruptobjects.htm

The undocumented SaveAsText and LoadFromText may help if an object is
corrupted or otherwise behaving weirdly.
At the debug/immediate window type:
Application.SaveAsText acForm,"MyForm","c:\form.txt
You can load the file into a new MDB.
Application.LoadFromText acForm,"MyForm","c:\from.txt"

Sample code at http://www.datastrat.com/Code/DocDatabase.txt for
saving all objects in an MDB.

Although I think there's a better solution out there somewhere.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Todos Menos [MSFT]]

I HAVE ALREADY POSTED THAT ARTICLE TONY READ THE NEWS KID

MDB IS DEAD

GO AND PLAY WITH YOUR BARBIES, SISSYPANTS!

 

[Max Moor]

Note that this person is really A a r o n K e m p f and that he is not
an employee of Microsoft.


Wrong.

Tony

Hi Tony,
Thanks for all the info. I'll dig into it.

You lost me on this post, though. What's this in reference to?

- Max

 

[Tony Toews [MVP]]

You lost me on this post, though. What's this in reference to?

I was replying to a posting that might not have made it onto Microsoft's news servers
hence the confusion. If you check Google groups on this thread you'll see what I
mean.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Max Moor]

I was replying to a posting that might not have made it onto Microsoft's
news servers hence the confusion. If you check Google groups on this
thread you'll see what I mean.

Tony

Ahh. Fair enough. Thanks again for the help...

Max

 

[Todos Menos [MSFT]]

oh does Tony ADMIT that my posts are blocked ON A PUBLIC SERVER?

Ballmer should be in prison for censorship

IT IS A PUBLIC SERVER, KIDS

 

[Max Moor]

Interesting that the import into a new database doesn't fix the
decompile. I've heard of this but haven't encountered that myself.

I can decompile!

I should have been more methodical to begin with. I finally created a
new DB, and imported objects a little at a time, checking the decompile after
each import to find the problem objects.

Oddly enough, it turned out to be the form resize code that I was using
from the Access 2002 Developer's Handbook. I use that code in another
application, and know there is nothing wrong with it. (It comes from the
bible after all.) I must have done something horrible along the way that
corrupted it. Everything is good now.

Thanks again for the pointers, Tony.

- Max