Solved

CLOSE VS QUIT to exit a database

Posted on 2006-05-10
3
317 Views
Last Modified: 2012-06-27
Which of these (close or quit) would work the best to exit a database in a multi-user environment where the data (be) is being accessed through a VB interface over a lan from more than one office?  
Or doesn't it make a difference?
We're having some lockfiles hang recently and I was wondering if this could be a problem.
The database was created with some forms having the "X" in the upper right hand corner to close and some having a "return to main menu" and then "exit the app" buttons.

Thanks.

0
Comment
Question by:tresrckr
  • 2
3 Comments
 
LVL 9

Accepted Solution

by:
ajkamp earned 125 total points
ID: 16652171
I don't think it makes much of a difference unless you want to run other commands or operations prior to shutdown, then you'd need to use "exit app" buttons.

0
 
LVL 9

Expert Comment

by:ajkamp
ID: 16652217
Access closes all objects when the application is closed (outside of using the task manager) in reverse order (I think) so it shouldn't leave any locking files open unless the app didn't close properly and it has hung in memory.
0
 

Author Comment

by:tresrckr
ID: 16659229
Thanks and we also found this.................
The issue we were having (or part of it) with the LDB files had to do with users having different permission levels on the folder where the database is located.
If someone had READ/WRITE/EXECUTE but not DELETE the ldb file was created but not deleted when the database closed.  
In addition when someone with READ only permission opened the database (first) NO ldb was created and users coming afterword that had more permission were given the "You won't be able to save changes, this database is READ ONLY".

In the past the databases were seldom shared outside of a single (or few) locations.  Permissions were granted to a specific group created at that time.  Now that we are sharing the data with many offices the ldb file has become more of an issue.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
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…

863 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now