|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 21st, 2006, 07:36 PM
posted to microsoft.public.access,microsoft.public.access.adp.sqlserver,microsoft.public.access.conversion,microsoft.public.access.devtoolkits,microsoft.public.access.gettingstarted,microsoft.public.access.interopoledde,microsoft.public.access.modulescoding
|
|||
|
|||
somebody please tell me how I delete an ".LDB" file
somebody please tell me how I delete an ".LDB" file
|
|
#2
September 21st, 2006, 07:44 PM
posted to microsoft.public.access,microsoft.public.access.adp.sqlserver,microsoft.public.access.conversion,microsoft.public.access.devtoolkits,microsoft.public.access.gettingstarted,microsoft.public.access.interopoledde,microsoft.public.access.modulescoding
|
|||
|
|||
|
somebody please tell me how I delete an ".LDB" file
LDB is the lock file created whenever the MDB file is open. It normally
deletes itself after use. To delete it manually, kick out all users, then simply select the file and delete it. -Ed "Trey Davis" wrote in message ... somebody please tell me how I delete an ".LDB" file
|
|
#3
September 21st, 2006, 07:47 PM
posted to microsoft.public.access,microsoft.public.access.adp.sqlserver,microsoft.public.access.conversion,microsoft.public.access.devtoolkits,microsoft.public.access.gettingstarted,microsoft.public.access.interopoledde,microsoft.public.access.modulescoding
|
|||
|
|||
|
somebody please tell me how I delete an ".LDB" file
WAIT!
what the!? I went back into the computer and the "LDB" file is no longer there! now what? "Ed Robichaud" wrote in message ... LDB is the lock file created whenever the MDB file is open. It normally deletes itself after use. To delete it manually, kick out all users, then simply select the file and delete it. -Ed "Trey Davis" wrote in message ... somebody please tell me how I delete an ".LDB" file
|
|
#4
September 21st, 2006, 08:07 PM
posted to microsoft.public.access,microsoft.public.access.adp.sqlserver,microsoft.public.access.conversion,microsoft.public.access.devtoolkits,microsoft.public.access.gettingstarted,microsoft.public.access.interopoledde,microsoft.public.access.modulescoding
|
|||
|
|||
|
somebody please tell me how I delete an ".LDB" file
Did you not read what Ed wrote? The LDB file should self-destruct as soon as
all users are out of the database, but it will be undeletable if the database is in use. -- Bill Mosca, MS Access MVP "Trey Davis" wrote in message ... WAIT! what the!? I went back into the computer and the "LDB" file is no longer there! now what? "Ed Robichaud" wrote in message ... LDB is the lock file created whenever the MDB file is open. It normally deletes itself after use. To delete it manually, kick out all users, then simply select the file and delete it. -Ed "Trey Davis" wrote in message ... somebody please tell me how I delete an ".LDB" file
|
|
#5
September 21st, 2006, 08:16 PM
posted to microsoft.public.access,microsoft.public.access.adp.sqlserver,microsoft.public.access.conversion,microsoft.public.access.devtoolkits,microsoft.public.access.gettingstarted,microsoft.public.access.interopoledde,microsoft.public.access.modulescoding
|
|||
|
|||
|
somebody please tell me how I delete an ".LDB" file
On Thu, 21 Sep 2006 13:47:24 -0500, "Trey Davis"
wrote: WAIT! what the!? I went back into the computer and the "LDB" file is no longer there! now what? Trey, did you bother to read Ed's response before replying to it? John W. Vinson[MVP]
|
|
#6
September 21st, 2006, 08:27 PM
posted to microsoft.public.access,microsoft.public.access.adp.sqlserver,microsoft.public.access.conversion,microsoft.public.access.devtoolkits,microsoft.public.access.gettingstarted,microsoft.public.access.interopoledde,microsoft.public.access.modulescoding
|
|||
|
|||
|
somebody please tell me how I delete an ".LDB" file
NO, it is DELETED, Trashed, Killed, no longer exists.
If all users have logged out of the database, Access automatically deletes the .ldb file. It is a temporary file that is no longer needed. "Trey Davis" wrote in message ... So your saying it becomes invisible or something? "Bill Mosca, Access MVP" wrote in message ... Did you not read what Ed wrote? The LDB file should self-destruct as soon as all users are out of the database, but it will be undeletable if the database is in use. -- Bill Mosca, MS Access MVP "Trey Davis" wrote in message ... WAIT! what the!? I went back into the computer and the "LDB" file is no longer there! now what? "Ed Robichaud" wrote in message ... LDB is the lock file created whenever the MDB file is open. It normally deletes itself after use. To delete it manually, kick out all users, then simply select the file and delete it. -Ed "Trey Davis" wrote in message ... somebody please tell me how I delete an ".LDB" file
|
|
#7
September 21st, 2006, 08:32 PM
posted to microsoft.public.access,microsoft.public.access.adp.sqlserver,microsoft.public.access.conversion,microsoft.public.access.devtoolkits,microsoft.public.access.gettingstarted,microsoft.public.access.interopoledde,microsoft.public.access.modulescoding
|
|||
|
|||
|
somebody please tell me how I delete an ".LDB" file
No, it is deleted. Access creates the file when the database is opened in a
shared mode. The LDB file is what controls record lockin gso that 2 people do not change a record at the same time. There is a good article that downloads with the Jet Utilities file at: http://support.microsoft.com/default...;en-us;Q176670 -- Bill Mosca, MS Access MVP "Trey Davis" wrote in message ... So your saying it becomes invisible or something? "Bill Mosca, Access MVP" wrote in message ... Did you not read what Ed wrote? The LDB file should self-destruct as soon as all users are out of the database, but it will be undeletable if the database is in use. -- Bill Mosca, MS Access MVP "Trey Davis" wrote in message ... WAIT! what the!? I went back into the computer and the "LDB" file is no longer there! now what? "Ed Robichaud" wrote in message ... LDB is the lock file created whenever the MDB file is open. It normally deletes itself after use. To delete it manually, kick out all users, then simply select the file and delete it. -Ed "Trey Davis" wrote in message ... somebody please tell me how I delete an ".LDB" file
|
|
#8
September 21st, 2006, 08:39 PM
posted to microsoft.public.access,microsoft.public.access.adp.sqlserver,microsoft.public.access.conversion,microsoft.public.access.devtoolkits,microsoft.public.access.gettingstarted,microsoft.public.access.interopoledde,microsoft.public.access.modulescoding
|
|||
|
|||
|
somebody please tell me how I delete an ".LDB" file
No, you can't. You could write code to copy it with another extension, but
what exactly is your purpose for manually deleting it? -- Bill Mosca, MS Access MVP "Trey Davis" wrote in message ... but * I * want to delete it. ME. Can I change a setting somewhere on my computer that tells Microsoft Access to not automatically delete the "LDB" file? "John Spencer" wrote in message ... NO, it is DELETED, Trashed, Killed, no longer exists. If all users have logged out of the database, Access automatically deletes the .ldb file. It is a temporary file that is no longer needed. "Trey Davis" wrote in message ... So your saying it becomes invisible or something? "Bill Mosca, Access MVP" wrote in message ... Did you not read what Ed wrote? The LDB file should self-destruct as soon as all users are out of the database, but it will be undeletable if the database is in use. -- Bill Mosca, MS Access MVP "Trey Davis" wrote in message ... WAIT! what the!? I went back into the computer and the "LDB" file is no longer there! now what? "Ed Robichaud" wrote in message ... LDB is the lock file created whenever the MDB file is open. It normally deletes itself after use. To delete it manually, kick out all users, then simply select the file and delete it. -Ed "Trey Davis" wrote in message ... somebody please tell me how I delete an ".LDB" file
|
|
#9
September 21st, 2006, 08:40 PM
posted to microsoft.public.access,microsoft.public.access.adp.sqlserver,microsoft.public.access.conversion,microsoft.public.access.devtoolkits,microsoft.public.access.gettingstarted,microsoft.public.access.interopoledde,microsoft.public.access.modulescoding
|
|||
|
|||
|
somebody please tell me how I delete an ".LDB" file
As far as I know, you cannot delete the .ldb if it is in use by Access.
There is no setting to tell Access not to delete the file. If the file is still there after all users have exited the database, then something "bad" happened. That could be that someone abnormally exited the application (pulled the plug on the computer) , there was a network problem, or Access crashed. "Trey Davis" wrote in message ... but * I * want to delete it. ME. Can I change a setting somewhere on my computer that tells Microsoft Access to not automatically delete the "LDB" file? "John Spencer" wrote in message ... NO, it is DELETED, Trashed, Killed, no longer exists. If all users have logged out of the database, Access automatically deletes the .ldb file. It is a temporary file that is no longer needed. "Trey Davis" wrote in message ... So your saying it becomes invisible or something? "Bill Mosca, Access MVP" wrote in message ... Did you not read what Ed wrote? The LDB file should self-destruct as soon as all users are out of the database, but it will be undeletable if the database is in use. -- Bill Mosca, MS Access MVP "Trey Davis" wrote in message ... WAIT! what the!? I went back into the computer and the "LDB" file is no longer there! now what? "Ed Robichaud" wrote in message ... LDB is the lock file created whenever the MDB file is open. It normally deletes itself after use. To delete it manually, kick out all users, then simply select the file and delete it. -Ed "Trey Davis" wrote in message ... somebody please tell me how I delete an ".LDB" file
|
|
#10
September 21st, 2006, 09:28 PM
posted to microsoft.public.access,microsoft.public.access.adp.sqlserver,microsoft.public.access.conversion,microsoft.public.access.devtoolkits,microsoft.public.access.gettingstarted,microsoft.public.access.interopoledde,microsoft.public.access.modulescoding
|
|||
|
|||
|
somebody please tell me how I delete an ".LDB" file
....is there a day care center for this community?
William Hindman "Trey Davis" wrote in message ... Is it possible to create my own "LDB" file? "John Vinson" wrote in message news  On Thu, 21 Sep 2006 13:47:24 -0500, "Trey Davis" wrote: WAIT! what the!? I went back into the computer and the "LDB" file is no longer there! now what? Trey, did you bother to read Ed's response before replying to it? John W. Vinson[MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
