DB Closes Automatically after 20min

[TheAceMan1]

Howdy all!

Have a DB (inherited) that [blue]automatically closes after 20 to 25 minutes with no keyboard or mouse activity during that time.[/blue] Time stretches out with activity.

[ol][li]There's no [blue]AutoExec[/blue] Macro.[/li]
[li]The few other macros do not execute anything to do with timing. In fact, I've deleted them.[/li]
[li]A hardcore search in VBA for [blue]TimerInterval[/blue] reveals no timers are being set.[/li]
[li]Importing all [blue]Objects[/blue] to a new DB is no help.[/li][/ol]
[purple]Any Ideas! . . . . .[/purple]

See Ya! . . . . . .

 

[ZmrAbdulla]

I believe you had a check hidden objects too..

I am not sure but a shot in the dark.. Any query that has a function to watch the time interval and that runs behind the seens.

________________________________________________________________________
Zameer Abdulla
Visit Me
Children are poor men's riches.

 

[alvechurchdata]

automatically closes after 20 to 25 minutes

If there's a five minute spread in the shutdown time then that suggests that something is polling the system clock every 300 seconds. I know it's a long shot but try a search for 300000.

I hate to say this but I have to ask - have you got Hidden Objects and System Objects visible in Tools|Options|View?

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[Hap007]

Dear AceMan,

Sounds like you have been given a lot of good advice, but still no solution, so I will offer a few suggestions. Perhaps one might hel.

Is there a form or code or macro that is set to run when Access starts up?

If so:
1) Try holding down the shift key when you open the access database and see if that help.
2) Try setting a break point in code. Then step through every line of code as the DB opens. When all the code has been run, if a timer is active in Access, that code should become visible. Then you would know what/where the close is running.
3) Check and see in your code window if you have any unknow code modules. Perhaps the original developer wrote a wizard or addin that is run when this database opens. any 'mda' files present.
4) How about any code in any linked databases?
5) You might want to open the database and then about 3 minutes in, change your 'system' clock back 5 minutes. If the app runs any longer, than you know a timer is checking the system clock somewhere.

Hope one of these suggestions helps,
Hap...


Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Add-on Solutions
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121