By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,304 Members | 1,739 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,304 IT Pros & Developers. It's quick & easy.

Access 2K Macros Appear from Nowhere?

P: n/a
In the VBA toolbar under Tools*Macros I see a dozen or so of my subs
listed as macros, which I didn't create as macros but had entered into
standard modules. I copy the code, delete the macro, but as soon as I
paste the code back into the module, the macro reappears. If I change
the name of the function, the macro name changes correspondingly. The
only way to eliminate them seems to be to create Private Subs out of
Subs.
What gives?
Strangely enough, this ADP will no longer allow me to create an ADE,
even after using the /decompile switch, giving me the message:
Microsoft Access was unable to create an MDE database...
lq

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

Lauren Quantrell wrote:
Strangely enough, this ADP will no longer allow me to create an ADE,
even after using the /decompile switch, giving me the message:
Microsoft Access was unable to create an MDE database...


TTBOMK ADEs/MDEs do not adjust/update their references easily (if at
all?).

So ...

TTBOMR if the Office Reference is say, Office 10, then you can create
an ADE/MDE only from within the Access of Office 10 (2002 I believe).
(Actually you can create the ADE/MDE in code [but that's another story]
from a non-matching version of Access but it won't run unless the
reference is on the machine where it's running, which seems to make
sense.)

Of course, the problem you experience may be caused by something
entirely different.

As for the Macros, probably someone will have a great explanation. Mine
is that underneath the glitz of Access lives the ghost of a Neanderthal.

Nov 13 '05 #2

P: n/a
Lyle,
Thanks for that. I've been creating ADE's from this Access2K regularly,
but now it won't - same machine, same Office, same Access... It's a
production machine so I don't change anything on it - I don't even let
it see the outside world.
lq

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.