Damaged mdb?

[John J.]

Today I closed my development mdb and the vba editor. I had written an
if-then routine but hadn't finished it. When trying to open the database
again (with a mainmenu form on start up) I got an error message (error has
occored) and Access asked me to make a backup. After opening the database
with the bypasskey I completed the code and everything seems to be fine
again.

My question is: could my mdb somehow be damaged by the above, which could
bite me later?

Thank you
John

 

[strive4peace]

Hi John,

first: uncheck the Compile On Demand default, which can be found on the
General tab of Tools, Options in the VBE window

second: never run code without compiling first

'~~~~~~~~~ Compile ~~~~~~~~~

Whenever you change code, references, or switch versions, you should
always compile before executing.

from the menu in a VBE (module) window: Debug, Compile

fix any errors on the yellow highlighted lines

keep compiling until nothing happens (this is good!)

~~
if you run code without compiling it, you risk corrupting your database


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[John J.]

Will do so...
Thanks for the tips!
John

Hi John,

first: uncheck the Compile On Demand default, which can be found on the
General tab of Tools, Options in the VBE window

second: never run code without compiling first

'~~~~~~~~~ Compile ~~~~~~~~~

Whenever you change code, references, or switch versions, you should
always compile before executing.

from the menu in a VBE (module) window: Debug, Compile

fix any errors on the yellow highlighted lines

keep compiling until nothing happens (this is good!)

~~
if you run code without compiling it, you risk corrupting your database


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[strive4peace]

you're welcome, John happy to help

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*