Solved

CLOSE VS QUIT to exit a database

Posted on 2006-05-10
3
324 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
[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
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

734 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