1

I created an AutoExec macro on Access 2007 and wanted to try a new function I created on VBA, but the function throws an error and everytime I open the database I get an error and the database closes, so I can't edit the code or the AutoExec macro because the application closes right after ending the AutoExec.

Any idea how can I open the database without having to run the AutoExec?

Deduplicator
  • 44,692
  • 7
  • 66
  • 118
user3614001
  • 13
  • 1
  • 5
  • I really need to enter the database because I didn't create a backup, my mistake :S – user3614001 Jul 24 '14 at 16:35
  • We like errors, they tell us their secrets. Mind to share? – Havenard Jul 24 '14 at 16:35
  • It only says "Found an error, and the application will be closed" or something like that, I'm using Access in spanish. The title of the error prompt just says "Microsoft Office Access" – user3614001 Jul 24 '14 at 16:38
  • this isn't a duplicate of the linked question, this one is for opening the database interactively, the linked question is for opening it programatically – Tim Abell Aug 16 '15 at 19:41

1 Answers1

2

Try opening the DB by holding down the SHIFT key until the DB is loaded. This will disable all macros before running. This way you can open the DB, correct the error and then try it again.

PaulFrancis
  • 5,748
  • 1
  • 19
  • 36