disable macros from ACCDB DB to MDB (1 Viewer)

yoyoman321 · Oct 18, 2018

I have a current Access DB saved an *.accdb. I am trying to convert this DB to the *.mdb format. However the current Access DB has embedded macros within it. How can I disable these macros so that I can convert this Access DB into the older MDB format??

Sincerely,

Patrick Q

PATRICK QUINN
SENIOR DATABASE DEVELOPER
NA ALIʻI, LLC
An 8(a)ccessible Native Hawaiian Owned Company

Ranman256 · Oct 18, 2018

in the new version, convert the forms EMBEDDED macros with:
“Convert Form’s Macro to Visual Basic” button.
THEN the form should convert backwards to the old way.
In the 'before' time.

GinaWhipp · Oct 19, 2018

Welcome to the Forum!

Note, after converting the macros you may still need to do some work as there are some new commands since .MDB and some of that code may not run. So be sure to test once downsized.

GinaWhipp · Oct 19, 2018

Thought I saw this before, also answered...

https://answers.microsoft.com/en-us...o-mdb-db/635f9b9c-08b5-44f6-8ce7-d2ee29a43c04

isladogs · Oct 19, 2018

In summary, it can be done, form by form using the built in tool but its tedious to do.

I never use macros and that also applies to embedded macros.
In fact when I first create a new database, I make sure I tick 'Always use event procedures' in the Object designers section of Access Options.

Strongly recommend you do so in future as well!

theDBguy · Oct 30, 2018

Hi Patrick,

yoyoman321 said:
How can I disable these macros so that I can convert this Access DB into the older MDB format??

Can you please elaborate on what exactly you mean by "disable?" Thanks.

disable macros from ACCDB DB to MDB (1 Viewer)

yoyoman321

New member

Ranman256

Well-known member

GinaWhipp

AWF VIP

GinaWhipp

AWF VIP

isladogs

MVP / VIP

theDBguy

I’m here to help

Similar threads

Users who are viewing this thread