CLOSE VS QUIT to exit a database

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.

tresrckrAsked:
Who is Participating?
 
ajkampConnect With a Mentor Commented:
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
 
ajkampCommented:
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
 
tresrckrAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.