Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Is it possible to 'close' an Access 2013 database automatically after it is idle?

Posted on 2015-02-17
16
Medium Priority
?
631 Views
Last Modified: 2015-02-23
I would like to have an Access 2013 database automatically 'close' when it sits idle for say 30 minutes.   I have a few people that are repeat offenders of keeping the database open when they leave for the day.   I am unable to do any development work because the database has been left open.  Is there an easy way to do this?   OR any way to do this?

Thank you,
Linda
0
Comment
Question by:Linda Quintana
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
16 Comments
 
LVL 22

Expert Comment

by:Flyster
ID: 40615775
jkaios had a nice solution to this problem:

ID: 39955121
Flyster
0
 
LVL 1

Author Comment

by:Linda Quintana
ID: 40615795
Thank you for the quick reply.  I will give this a try tomorrow as it seems like it will work perfectly.

Linda
0
 
LVL 29

Expert Comment

by:IrogSinta
ID: 40615824
jkaios' solution doesn't really take user activity into account. It just shuts down the database after a predetermined time.  If someone is actively using the database, the countdown should restart.  The solution here is actually the first post in the link where Jim pointed out Microsoft's Knowledge Base article on How to Detect User Idle Time or Inactivity .

As for your being unable to do development work while because the database has been left open, your users should really have their own copy of the database (preferably the accde version) rather than everyone sharing the main database.  That way you can make changes and put out new versions anytime.  

Ron
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 2000 total points
ID: 40615888
Peter at PetersSoftware has this solution worked out for you (and free) ... with sample db

Inactive Shut Down Control
Inactive Shut Down Control is a form for Microsoft® Access® that gives you the ability to automatically shut down your Access application after a specified period of user inactivity.

http://peterssoftware.com/isd.htm

I have fully tested this as well.

And optionally (also free w/ sample db):
Force Shut Down
Automatically close all copies of your networked application front-end from one workstation.

http://peterssoftware.com/fsd.htm
I built an entire Forced Shutdown module that is used nightly during backup.  Virtually bullet proof and in use for more than five years.  I have 45 back ends with corresponding front ends, with as many as 100+ users in some front ends.  Of course, when I run backup circa 1700 each night, most users are out. But ... if some 200 users were in all FE ... all would be shut down :-)

mx
0
 
LVL 1

Author Comment

by:Linda Quintana
ID: 40619186
So, is this solution only available for a 'split' database?   The database I'm working with is not split and I will not be splitting it.

Thank you.
Linda
0
 
LVL 75
ID: 40619542
The Inactive Shutdown will work on a db that is not split ...
Download the app with sample db ... and you can see exactly how it works.

And you could probably make the FSD work also, but it would have to ping an external db to check to check for the shutdown flag - that you would be setting.

Curious ... if there is more that one user in your db, why are you not splitting it?
All professional Access dbs user the tried and true split configuration, for multiple reasons.
Splitting is very easy to do.

mx
0
 
LVL 1

Author Comment

by:Linda Quintana
ID: 40619589
mx -
I have split databases for multiple user environments.   However, this is a 'Microsoft Template' for Inventory tracking and because of the code, it is difficult (nearly impossible) to split without a whole lot of work (which defeats the purpose of using a template).  Plus there are only 2 users that will be accessing the database and NOT at the same time.  

I have downloaded and looked at the sample db, so I'm pretty comfortable with trying to execute this remedy.  I appreciate all the feedback and information.  This site is a great tool for those 'hard to find' answers to development questions.

lq
0
 
LVL 75
ID: 40619611
LOTS of cool stuff on Peters's site.
Lots of other cool sites also.

I suppose with two non simultaneous users - not really a big deal. But ... the one downside that remains is ... should the db become corrupt, you may lose all data, wherein a split config ... if FE becomes corrupt - BE (with data) is still intact :-)

So ... just for clarification ... isn't the Template just an ACCDB?
If so ... to split, all you have to do is move the tables out and Link ... and there is a wizard for that.
Again ... just curious ...

mx
0
 
LVL 1

Author Comment

by:Linda Quintana
ID: 40619622
mx-
Yes the template is an 'accdb' and I actually tried to split the database and it split just fine.   However, all kinds of macro errors kept occurring and prevented me from using the db.   So I did some 'google searches' specific to this database template and several people posted that they wanted to split it and were having difficulty with the code not working.  I decided it was not worth the time and effort so I just abandoned my research to find a solution.  Most of the solutions I found were going to require a lot of recoding and in my circumstance, it just wasn't worth the time.   The good news is that our IT group backs up files daily.   So if it ever gets corrupt, we will loose minimal data as this is not even a 'high usage' database.

lq
0
 
LVL 75
ID: 40619670
Well, just make FREQUENT backups.
In Windows Explorer ... select db, Control C + Control V ... instant 2 second backup.

Hey ... can you give me a link to this template ... I want to see what's up ...

mx
0
 
LVL 1

Author Comment

by:Linda Quintana
ID: 40620319
mx -

Here is the link to download the inventory management database template:

http://bit.ly/fXuPqF

Have fun....and thanks again for your help.

lq
0
 
LVL 75
ID: 40620337
OOOK ... this is an A2010 Web Database ... connected to Sharepoint tables ?

"The Access 2010 Goods web database template creates a ready-to-use database that lets you track orders, products, invoices, inventory, and other data associated with running a business that sells goods. This article shows you how to start using the Goods web database."


That is an entirely different matter ... but I will check it out.
0
 
LVL 1

Author Comment

by:Linda Quintana
ID: 40621126
I actually converted it to a local database first instead of using it as a web based database.
have fun with it though.

Regards,
LQ
0
 
LVL 75
ID: 40621777
And you still had 'code' issues splitting ?
A2010 Web Databases were anything but popular.
0
 
LVL 1

Author Comment

by:Linda Quintana
ID: 40626929
Yes -- after some time spent searching for answers, I found several people that were experiencing the same problem with this database.   So, since it was not critical to my application, I just decided not to split the database.

Thanks for the follow up and happy investigating.

Regards,
LQ
0
 
LVL 75
ID: 40627053
We have an intern ... and I am going to have him look at it.  He has looked at templates before.

mx
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question