Forums
This topic is locked
Lockfile problem
26 Jan 2002 14:33:02 Q Qwerty posted:
This is a real technical one (I think). I'm using an Access 2000 DB with VBSscript. Now in some strange way errors are occurring in strange ways. For example, when opening the homepage then the following error message appears:Microsoft VBScript runtime error '800a01fb'
An exception occurred: 'Ads.Open'
/index.asp, line 10
In the database directory two new files have been created, the so called Access.Lockfile.9 with the extension ldb. I can't delete them. They seem to be some sort of temporary Access files which seem to block access to the database. Maybe it has something to do with the ADO constants, defined by Ultradev, I'm just guessing. I would really appreciate any help on this because my rather succesfull website is down constantly this way. Thanks everybody in advance for your answers.
Rein
Replies
Replied 26 Jan 2002 18:14:01
26 Jan 2002 18:14:01 Viktor Farcic replied:
You guessed right. Access creates .ldb file whenever DB is open. That means that whenever somebody is using it, Access creates .ldb file and you can't delete it. At least, this is how it works on desktop and I suppose that it's acting in the same way when it's OnLine.
I used SQL Server almost from the start (just one or two sites with Access) so I don't know much about 'how Access is acting while it's on web'. I know that it doesn't handle well many users at the same time, that it's much slower... Move to SQL Server if you can. Logic is simple, both programs are databases but Access is made to work on desktop and SQL to work on network.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
This is a real technical one (I think). I'm using an Access 2000 DB with VBSscript. Now in some strange way errors are occurring in strange ways. For example, when opening the homepage then the following error message appears:
Microsoft VBScript runtime error '800a01fb'
An exception occurred: 'Ads.Open'
/index.asp, line 10
In the database directory two new files have been created, the so called Access.Lockfile.9 with the extension ldb. I can't delete them. They seem to be some sort of temporary Access files which seem to block access to the database. Maybe it has something to do with the ADO constants, defined by Ultradev, I'm just guessing. I would really appreciate any help on this because my rather succesfull website is down constantly this way. Thanks everybody in advance for your answers.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Viktor Farcic
TalkZone Manager
Edited by - vfarcic on 26 Jan 2002 20:37:10
I used SQL Server almost from the start (just one or two sites with Access) so I don't know much about 'how Access is acting while it's on web'. I know that it doesn't handle well many users at the same time, that it's much slower... Move to SQL Server if you can. Logic is simple, both programs are databases but Access is made to work on desktop and SQL to work on network.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
This is a real technical one (I think). I'm using an Access 2000 DB with VBSscript. Now in some strange way errors are occurring in strange ways. For example, when opening the homepage then the following error message appears:
Microsoft VBScript runtime error '800a01fb'
An exception occurred: 'Ads.Open'
/index.asp, line 10
In the database directory two new files have been created, the so called Access.Lockfile.9 with the extension ldb. I can't delete them. They seem to be some sort of temporary Access files which seem to block access to the database. Maybe it has something to do with the ADO constants, defined by Ultradev, I'm just guessing. I would really appreciate any help on this because my rather succesfull website is down constantly this way. Thanks everybody in advance for your answers.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Viktor Farcic
TalkZone Manager
Edited by - vfarcic on 26 Jan 2002 20:37:10