A bug in Access?

[GWhiz]

Hi, folks!

Ran into an interesting problem on an Access database. Not sure how I got there, or how to get out.

Program ran fine with all changes I had made until I re-booted the following day. Started getting error messages, all problems I had solved before, so I wasn't too worried. Simply fix a few things in code, and that takes care of it.

Except when I went into design view on the form where I thought the problem was -- would not let me into the code module for that form. At all. Period. Finis. End of story.

I thought I may have inadvertently created an MDE file -- but MDE files lock you out of design view entirely, not just out of the code module. Can access other form modules in the same database -- but not on the main form.

Have no idea what might cause that.

Anyone else run into a problem like that?

Thank you so much for any help you can provide!

Respectfully,

GWhiz

 

[TCerven]

Hello There,

This happened to me as well. I was not able to fix it. I had to transfere everyting into a new database. I would be careful and save your files in a different location because my database evetually crashed and I lost loads of data.

I would like to know what happened in my case as well.

Best of Luck!

 

[scking]

I would like you to know I don't have the answer, BUT I occasionally get forms that become corrupted and correct them by copying the form, deleting the old form, and renaming the copied for to the old form name. This might help.

Steve King Professional growth follows a healthy professional curiosity

 

[khood]

GWhiz:

I am working with Access 2k & have had a similar problem, but is not limited to one form. When VB is started (when you look at the module), you will notice that system resources are suddenly gone.

Try this - start your database, then look under Help-About Access-System Info. Note the % system resources available. Now view the code for that form. From within VB, look at your system resources. If you go from 65-70% to 10% or less, then you need to do what TCervan is recommending above:

Rename your current database. Create a new database with the original name, then choose File-Get External Data-Import -- then choose the original database. It will allow you to import all tables, forms, etc.

Ken Hood