Access keeps closing down

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.
 
M

ManningFan

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).
 
A

Anne

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
 
B

Bush

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
 
Top