Solved

CLOSE VS QUIT to exit a database

Posted on 2006-05-10
3
320 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

830 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