[thelist] ASP: residual database files Follow Up

[Chris W. Parker]

so then mike, would say that it is because i am not closing all my db
connections or more likely that the directory does not have delete
permissions?

in the article you gave, microsoft suggests giving the db directory full
control rights to the users that use the database. but at the same time
set read only (or i guess, read and write) only permissions on the db
itself. is this as simple as righ-clicking on the folder and setting the
permissions and then righ-clicking on the db and setting the
permissions?


thanks for the info.
chris.

> -----Original Message-----
> From: Mike Carlson [mailto:domitianx at domitianx.com]
> Sent: Friday, July 19, 2002 11:34 AM
> To: thelist at lists.evolt.org; thelist at lists.evolt.org
> Subject: RE: [thelist] ASP: residual database files Follow Up
>
>
> .lbd files are not log files. They are "lock" files. It tells
> the database
> who has what records open at what time. This is so a person
> cannot update the
> same record at the exact same moment in time. You cannot turn
> it off if you
> are sharing the database to more than one user, which you are
> on the web. Its
> one of the downsides of using Access. MS SQL does not use a
> lock file. Its
> all handled internally by the engine.
>
> Here is the lowdown on .ldb files:
>
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;q136128
>
> Mike
> http://www.uselessthoughts.com
>
>
> 	-----Original Message-----
> 	From: Jay Blanchard [mailto:jay.blanchard at niicommunications.com]
> 	Sent: Fri 7/19/2002 1:30 PM
> 	To: thelist at lists.evolt.org
> 	Cc:
> 	Subject: RE: [thelist] ASP: residual database files Follow Up
>
>
>
> 	--
> 	[snip]
> 	They are database log files created by the M$ system
> you are using.
> 	[/snip]
>
> 	There are settings on Access and M$ SQL Server to disable the
> creation of
> 	log files, if you want to disable them. Make sure you
> keep back-ups!
>
> 	Jay
>
> 	"Rumors of my demise are greatly exaggerated"
>
> 	*************************************
> 	* Want to meet other PHP developers *
> 	* in your area? Check out:          *
> 	* http://php.meetup.com/            *
> 	* No developer is an island ...     *
> 	*************************************
> 	--
> 	[ winmail.dat was deleted, please don't send
> attachments with your
> message. ]
> 	--
>
>
> 	--
> 	For unsubscribe and other options, including
> 	the Tip Harvester and archive of thelist go to:
> 	http://lists.evolt.org Workers of the Web, evolt !
>
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
> http://lists.evolt.org Workers of the Web, evolt !
>