PC Review


Reply
Thread Tools Rate Thread

Corrupt VBA code?

 
 
Byron
Guest
Posts: n/a
 
      4th Jun 2004
I do not normally post to more that one thread, however,
I have decided to post this here in order to try to get
some assistance.

I am using Access 2003 with database as 2002. I am able
to open the database, but if I just let it set for a few
minutes it presents the error box that tells me that an
error has occurred. It request: do I want to backup the
database file and do I want to send the error to
Micorsoft.

I can even open an exising form in design view if I do it
rather quickly. If I attemp in any way to go to the Code
window or open the form, I get the error immediately.

I have tried to compact and repair. I have even tried to
import some or all of the forms, etc. to an empty
batabase. Nothing seems to make any headway.

If anyone has any way to get to any of the code it would
be appreciated.

Byron

 
Reply With Quote
 
 
 
 
Allen Browne
Guest
Posts: n/a
 
      4th Jun 2004
Any forms using the Timer event?

Any VBA addins?

Any startup code?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Byron" <(E-Mail Removed)> wrote in message
news:1826601c449f0$54c0d9c0$(E-Mail Removed)...
> I do not normally post to more that one thread, however,
> I have decided to post this here in order to try to get
> some assistance.
>
> I am using Access 2003 with database as 2002. I am able
> to open the database, but if I just let it set for a few
> minutes it presents the error box that tells me that an
> error has occurred. It request: do I want to backup the
> database file and do I want to send the error to
> Micorsoft.
>
> I can even open an exising form in design view if I do it
> rather quickly. If I attemp in any way to go to the Code
> window or open the form, I get the error immediately.
>
> I have tried to compact and repair. I have even tried to
> import some or all of the forms, etc. to an empty
> batabase. Nothing seems to make any headway.
>
> If anyone has any way to get to any of the code it would
> be appreciated.
>
> Byron
>



 
Reply With Quote
 
gandalf
Guest
Posts: n/a
 
      4th Jun 2004
You could try the undocumented command switch /decompile

Create a shorcut with the commandparameters

"C:\Program Files\Microsoft
Office\Office\MSACCESS.EXE" "/decompile"

(where "C:\Program Files\Microsoft
Office\Office\MSACCESS.EXE" is the location of your
msaccess file)

Then open a test-backup of your corrupt database
(always work on copies)
If succesfull it will display briefly code is compiled to
the latest vba ...

Close Access
Remove the /decompile (not for normal use)
Compact and repair the test-backup

Open the test-backup and see if nothing is missing

>-----Original Message-----
>I do not normally post to more that one thread, however,
>I have decided to post this here in order to try to get
>some assistance.
>
>I am using Access 2003 with database as 2002. I am able
>to open the database, but if I just let it set for a few
>minutes it presents the error box that tells me that an
>error has occurred. It request: do I want to backup the
>database file and do I want to send the error to
>Micorsoft.
>
>I can even open an exising form in design view if I do it
>rather quickly. If I attemp in any way to go to the Code
>window or open the form, I get the error immediately.
>
>I have tried to compact and repair. I have even tried to
>import some or all of the forms, etc. to an empty
>batabase. Nothing seems to make any headway.
>
>If anyone has any way to get to any of the code it would
>be appreciated.
>
>Byron
>
>.
>

 
Reply With Quote
 
Byron
Guest
Posts: n/a
 
      4th Jun 2004
Thanks for the replies. I will try the "decompile"
process. I had forgotten about that.

Allen,

There are no timer events.

There are no VBA Addins, but I am using Seven Leban's
monthly calendar and Albert Kallal's merge to word
solution.

I do have some rather simple code in the OnCurrent event
of the first form, but I am not opening or attempting to
open this form. I had not yet set any form to open on
startup.

Your assistance is appreciated.

Byron

>-----Original Message-----
>Any forms using the Timer event?
>
>Any VBA addins?
>
>Any startup code?
>
>--
>Allen Browne - Microsoft MVP. Perth, Western Australia.
>Tips for Access users - http://allenbrowne.com/tips.html
>Reply to group, rather than allenbrowne at mvps dot org.
>
>"Byron" <(E-Mail Removed)> wrote in

message
>news:1826601c449f0$54c0d9c0$(E-Mail Removed)...
>> I do not normally post to more that one thread,

however,
>> I have decided to post this here in order to try to get
>> some assistance.
>>
>> I am using Access 2003 with database as 2002. I am

able
>> to open the database, but if I just let it set for a

few
>> minutes it presents the error box that tells me that an
>> error has occurred. It request: do I want to backup the
>> database file and do I want to send the error to
>> Micorsoft.
>>
>> I can even open an exising form in design view if I do

it
>> rather quickly. If I attemp in any way to go to the

Code
>> window or open the form, I get the error immediately.
>>
>> I have tried to compact and repair. I have even tried

to
>> import some or all of the forms, etc. to an empty
>> batabase. Nothing seems to make any headway.
>>
>> If anyone has any way to get to any of the code it

would
>> be appreciated.
>>
>> Byron
>>

>
>
>.
>

 
Reply With Quote
 
Byron
Guest
Posts: n/a
 
      4th Jun 2004
Just wanted to let everyone know:

The "decompile" worked to let me open the application and
get to the VBA code window.

It is this kind of situation that make discussion groups
like this so benificial.

Thanks, again.

Byron

>-----Original Message-----
>You could try the undocumented command switch /decompile
>
>Create a shorcut with the commandparameters
>
>"C:\Program Files\Microsoft
>Office\Office\MSACCESS.EXE" "/decompile"
>
>(where "C:\Program Files\Microsoft
>Office\Office\MSACCESS.EXE" is the location of your
>msaccess file)
>
>Then open a test-backup of your corrupt database
>(always work on copies)
>If succesfull it will display briefly code is compiled

to
>the latest vba ...
>
>Close Access
>Remove the /decompile (not for normal use)
>Compact and repair the test-backup
>
>Open the test-backup and see if nothing is missing
>
>>-----Original Message-----
>>I do not normally post to more that one thread,

however,
>>I have decided to post this here in order to try to get
>>some assistance.
>>
>>I am using Access 2003 with database as 2002. I am

able
>>to open the database, but if I just let it set for a

few
>>minutes it presents the error box that tells me that an
>>error has occurred. It request: do I want to backup the
>>database file and do I want to send the error to
>>Micorsoft.
>>
>>I can even open an exising form in design view if I do

it
>>rather quickly. If I attemp in any way to go to the

Code
>>window or open the form, I get the error immediately.
>>
>>I have tried to compact and repair. I have even tried

to
>>import some or all of the forms, etc. to an empty
>>batabase. Nothing seems to make any headway.
>>
>>If anyone has any way to get to any of the code it

would
>>be appreciated.
>>
>>Byron
>>
>>.
>>

>.
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Your registry might be corrupt (Code 19) =?Utf-8?B?SmFjY2k=?= Microsoft Windows 2000 1 11th Dec 2004 03:12 PM
regstry might be corrupt code 19 gunnar Microsoft Windows 2000 Registry Archive 2 6th Apr 2004 02:41 PM
regstry might be corrupt code 19 gunnar Microsoft Windows 2000 Registry Archive 0 6th Apr 2004 10:42 AM
Corrupt DB - VB code problem? BarbaraC Microsoft Access VBA Modules 3 26th Feb 2004 03:08 AM
Registry corrupt code 19 =?Utf-8?B?TGl6emE=?= Microsoft Windows 2000 1 15th Dec 2003 01:13 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:46 PM.