Access keeps closing down

  • Thread starter Thread starter Bush
  • Start date Start date
B

Bush

I have inherited a Access database which I need to modify however when
i try and swap from the design view to view (normal view) Access shuts
itself down. Any ideas? probably something little but I cant find it.
 
The obvious first step is to do a Repair/Compact.

After that, take a look at the startup screen. I've seen vindictive
coders (on their way out) throw code into databases that makes them
useless. Check for any code that calls an exit app-type function (i.e.
DoCmd.Quit or something similar).
 
Look at the queries behind the form. See if you can run them. If they are
ok, you need to look at the code behind the form
 
Cheers, I had a look in the code and found the creator of the database
had dropped in a sneaky code to close Access when anything was altered.

All sorted
 
Back
Top