Kill open file

[throwdini]

I have created a front end in access for a database that should expire after a period of time. I would like the front end to "self-destruct" once the time period has elapsed, leaving the back end data alone.

Is it possible to use the kill statement to delete the front end being used? Ideally what I would like it to do is:

docmd.quit
kill "front_end.mdb"

but I can't seem to get it to work.
Thanks,
Jay

Any help would be greatly appreciated.

 

[VBslammer]

You might be able to do that using a Libary database referenced by your frontend. VBSlammer

Unemployed in Houston, Texas

 

[oharab]

Instead of destroying the file, why don't you just make it so you can't get into it? Then ask them to pay for an access code that will unlock the file so they can continue using it.

B ----------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

----------------------------------------

 

[throwdini]

I currently have it set up to expire by just shutting down (docmd.quit), but I'm not to crazy about it. One, someone could most likely hack around it. Two, this database is very task specific and should only be used for the specified purpose. Once the task is complete the program should not be used. I would be happy to develope a data maintenance system for more long term issues, but that is not what this is for.

I have no idea what the library sollution is, if you could give me a hand with that I would appreciate it.

Thanks,
Jay