Questions about rebuilding a db

[Victoria]

Lately I've notices my database freezing from time to time, so I tried the
following...
a) created a new data base
b) imported all tables, queries, forms, ...... ,modules
c) reset the References
d) reset the Startup options
e) compile

Everything is working great now, but I have a few questions about this
process. Did I miss any crucial steps? (don't want any surprises later) Is
there a prefered order to do these steps? Finally, the database is now about
30% smaller, even though I was regularly compiling, compacting/repairing the
former one. I'd like to know why this might be so.

many thanks
Victoria

 

[Victoria]

I'm sooooo sorry I posted this 3 times. There was a posting above mine dated
2 days from now, so I just didn't see it.

duh
Victoria

 

[Stefan Hoffmann]

hi Victoria,

Everything is working great now, but I have a few questions about this
process. Did I miss any crucial steps? (don't want any surprises later)

Crucial? Not necessarily, but imho an important one:

a) created a new data base

- disable Name AutoCorrect of the new database (File\Options).
- enable Compact On Close (File\Options).
- enable Option Explicit (VBA IDE\Tools\Editor).

b) imported all tables, queries, forms, ...... ,modules

- check whether all code modules have the Option Explicit directive at
the top of the module.

c) reset the References

- compile

d) reset the Startup options
e) compile

Is there a prefered order to do these steps? Finally, the database is now about
30% smaller, even though I was regularly compiling, compacting/repairing the
former one. I'd like to know why this might be so.

While development, compact and repair may not remove all unnecessary
artifacts. So this may happen. In most cases where I had issues like
this, it was due to some kind of code corruption.

So I'm doing the steps above on a regular manner during development.


mfG
--> stefan <--

 

[Victoria]

Stefan Thank you for some great insights. Victoria

 

[Dirk Goldgar]

- enable Compact On Close (File\Options).

Enable? Although I'm personally ambivalent about this option, I know
there's a certain amount of sentiment *against* using Compact On Close. Did
you really mean to suggest that Victoria should enable it, or did you mean
that she should *disable* it?

 

[Stefan Hoffmann]

hi Dirk,

Enable? Although I'm personally ambivalent about this option, I know
there's a certain amount of sentiment *against* using Compact On Close.
Did you really mean to suggest that Victoria should enable it, or did
you mean that she should *disable* it?

Despite its problems in the past, I use it in all projects running not
as a compiled *.mde.


mfG
--> stefan <--