ldb not relasing after close

[Guest]

Hi

I have posted a similar question before. I need some further assistance.

I have an access application which runs automatically on a scheduler each
day.
Here's the problem:
When the scheduler runs the application the ldb file does not release itself
and stays open. when I try to delete it it says that it is being used but no
one is in it.
When I run the program in manual mode there's no problem. The ldb shuts
itself after the process gets run.

any ideas? Thanks

 

[Larry Daugherty]

When your program is run by the Scheduler is there something that
causes it to execute "Application.Quit" when it's done. It sounds
like your application has simply been left running.

HTH

 

[Guest]

I had this happen to me not long ago. I run an MS Access application on a
server share in my company. The lock file would not release so I could make
design changes. I found that a lock file had been created in my documents
folder, and once I deleted the second lock file, the lock file on the server
was released as well. Can't explain it, but that's how it happened.