[AccessD] ldb file

[Rocky Smolin]

It's unclear from this link:

Access stopped closing and deleting the LDB file - Microsoft Community
<https://answers.microsoft.com/en-us/msoffice/forum/all/access-stopped-closing-and-deleting-the-ldb-file/81399370-68bc-48bf-ac17-788c289eab6a>

what version of Office they're referring to but it's apparently a known
link with a patch.  I sent this to my client who will forward it to the IT
guy.

r

On Wed, Aug 17, 2022 at 8:21 PM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> Doncha just love users that don't give you full information?
>
> What happens when he tries to delete the file. What error message (if any)
>
> First thing is to check whether he is logged in as a user that has delete
> writes on the
> directory.  Then check if someone  set the directory to read only .
> Also check the properties of the two files.
> If he's access the folder over the network, check the share properties as
> well as the actual
> directory properties.
>
> A reboot won't do any good if the files or directory are locked because of
> a rights issue.
>
>
> On 17 Aug 2022 at 19:49, Rocky Smolin wrote:
>
> > The file in question is on the server. I advised him to reboot the
> > server. But he didn't know how to do that. So He's calling his IT
> > person. Would the reb oot 'release' those files?
> >
> > tks
> >
> > r
> >
> > On Wed, Aug 17, 2022 at 6:06 PM David Emerson <newsgrps at dalyn.co.nz>
> > wrote:
> >
> > > Hi Rocky,
> > >
> > > Not sure how the file got into the situation but hammer approach -
> > > reboot the computer.
> > >
> > > Regards
> > >
> > > David Emerson
> > > Dalyn Software Ltd
> > > Wellington, New Zealand
> > >
> > >
> > > -----Original Message-----
> > > From: AccessD
> > > <accessd-bounces+newsgrps=dalyn.co.nz at databaseadvisors.com> On
> > > Behalf Of Rocky Smolin Sent: Thursday, 18 August 2022 12:47 pm To:
> > > Access Developers discussion and problem solving
> > > <accessd at databaseadvisors.com>; Off Topic
> > > <dba-ot at databaseadvisors.com> Subject: [AccessD] ldb file
> > >
> > > I have a user who is trying to install an update to the back end
> > > that I sent him.  But first he wants to move the existing back end
> > > to a different folder.  But the .ldb file is still there. And
> > > windows will not allow him to delete either the database of the ldb
> > > file.
> > >
> > > I had him send me the .ldb file, and it has records in it for four
> > > users. For all four users the Logged On property for all four = No,
> > > the Suspect property = No, and the Committed Transactions = N/A.
> > >
> > > Question 1 is - how can he delete this .ldb file and the associated
> > > mdb? Question 2 is - how did they create this situation so they can
> > > avoid doing it again in the future?
> > >
> > > MTIA
> > >
> > > Rocky
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>