[thelist] Online Database Dumb Question Revisited
Administrative HQ
english_offline at yahoo.com
Thu Mar 3 13:39:51 CST 2005
Hello.
It happened again. I asked my hosting company to run
the suggested check and got the following results:
====
Handle v2.2
Copyright (C) 1997-2004 Mark Russinovich
Sysinternals - www.sysinternals.com
w3wp.exe pid: 2520
D:\Inetpub\ahavaschesed.net\wwwRoot\ingla.mdb
w3wp.exe pid: 2520
D:\Inetpub\ahavaschesed.net\wwwRoot
w3wp.exe pid: 2520
D:\Inetpub\ahavaschesed.net\wwwRoot\ingla.mdb
w3wp.exe pid: 2520
D:\Inetpub\ahavaschesed.net\wwwRoot\ingla.ldb
w3wp.exe pid: 2520
D:\Inetpub\ahavaschesed.net\wwwRoot\ingla.ldb
=====
The browser and ftp client were long closed. I can
access and edit the DB online, but cannot delete, etc.
with the FTP client.
Is this because I modified the DB or maybe it was
happening before and I just didn't have any reason to
try to delete the file?
Any idea what I can do about this?
Any and all help greatly appreciated.
--- Ken Schaefer <Ken at adOpenStatic.com> wrote:
> So, given that they had to restart your site to get
> the file "unlocked"
> (whatever that means), I suspect that you have some
> kind of file system lock
> on the DB. I would ask your host to run Handle.exe
> from www.sysinternals.com
> to find out what process has what type of file
> system lock on the .mdb file
> in question.
>
> Cheers
> Ken
>
> : -----Original Message-----
> : From: thelist-bounces at lists.evolt.org
> [mailto:thelist-
> : bounces at lists.evolt.org] On Behalf Of
> Administrative HQ
> : Sent: Thursday, 3 March 2005 8:46 AM
> : To: thelist at lists.evolt.org
> : Subject: [thelist] Online Database Dumb Question
> :
> : Hello.
> :
> : I have an online database to which entires are
> made by
> : ASP forms. Manual editing is possible.
> :
> : I didn't create the system and don't know anything
> : about ASP or much about data bases.
> :
> : I used Access to add some columns to the data
> base,
> : with an eye to manually adding information, using
> the
> : "Edit" function. These columns are unrelated to
> : anything called by the VBscript in the
> forms...they're
> : just sitting in the data base.
> :
> : I used the regular form to create a data base
> entry
> : (new user) and it worked fine...making the right
> : entries in the dbase but having no effect, of
> course,
> : on the new fields.
> :
> : I did not make any manually entries as I was
> merely
> : trying to see if the new columns came up right and
> if
> : the forms still worked.
> :
> : But then, I was unable to rename, delete or
> replace
> : the dbase. Two ftp clients returned error notices
> : saying that the file was in use by another process
> : (although Access, IE, etc,. had been closed. The
> : support folks on my host had to reboot the site to
> : "unlock" the mdb file, which had "not closed
> : properly".
> :
> : Can I not do what I'm trying to do, or is this
> just a
> : quirk?
> :
> : Any help or pointers would be greatly appreciated.
> --
>
> * * Please support the community that supports you.
> * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip
> Harvester
> and archives of thelist go to:
> http://lists.evolt.org
> Workers of the Web, evolt !
>
__________________________________
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
http://birthday.yahoo.com/netrospective/
More information about the thelist
mailing list