compact and repair

[tracktraining]

Hi Everyone,

I have been getting this error message "There was an error executing the
command". After reading online for hours, i found out about "compact and
repair". Would i perform this on the .mdb version and then make a new .mde?

Can anyone explain to me the process?


Thanks so much!

 

[Gina Whipp]

tracktraining,

Are trying to make an .mde and that is when you get this error? If so, open
your database to the container window... go to Tools - Database Utilities -
Compact & Repair Database...

However, I would first Compile the code and fix any errors there... go to
the Forms (tab), then select the Code button from the Menu Bar... once that
window opens up select Debug - Compile... and fix any errors that might
occur. THEN run Compact & Repair. (I would make sure at the top of every
module has...

Option Compare Database
Option Explicit

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[tracktraining]

No, the error happens after the .mde. And only some computer gets it.

I did complie and fixed any problems that cam up due to the code before
making the .mde.

And at the top of all my module i do have those statement that you mentioned.

So i do have to perform the compact and repair at the .mdb level then make
the .mde?

 

[Gina Whipp]

tracktraining,

I am now confused...

You first state "... the error happens after the .mde. And only some
computer gets it."

Then you state "So i do have to perform the compact and repair at the .mdb
level then make the .mde?"

So when does the error happen? While an .mdb or after you have created the
..mde? IF it happens while the database is an .mdb AND only on some machines
then you need to chaeck the references on a machine where it works and
compare them to a machine that does not work. However, it is happening
AFTER the .mde has been created, it might still be a reference issue OF it
code be you need better error handling. When you get this error does it
give you the option to Debug? Of course that would only apply to an .mdb

I should also note that Compact & Repair does not 'fix' code. That would be
the job of the developer. If I include a command with no error handling,
Compact & Repair will not insert it for me.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm