Frustrating Access Error after Upgrade

[falstaff]

Using Access 97 on a web site I have been running happily for many years, no problems. Moved website to a new server and all of a suddent I'm getting random erorrs of<br><br>Microsoft ODBC Microsoft Access 97 Driver <br>Couldn't update; currently locked by user 'admin' on machine TIXLINK1<br><br>when I'm doing inserts or updates. Searched alta vista for &quot;Microsoft ODBC Microsoft Access 97 Driver update currently locked by user admin on machine&quot; and came up with thousands of pages that have clearly had the same error but no solutions!<br><br>Why has my site started to fail ....<br>

 

[palbano]

Dear falstaff,<br><br>Search on msdn.microsoft.com instead of alta vista. There is a knowledge base article you should find that discusses this issue as it pertains to folder permissions etc.<br><br>Good luck<br>-pete

 

[falstaff]

Hi<br><br>Thanks for the speed of response - I'd agree if the fault was all the time but this is random and on a database in a directory with everybody/all privileges - using the search at msdn yields nothing I'm afraid <br><br>I'll keep tearing my hair out ....<br>robert

 

[NickBulka]

You might find something useful here:<br><A HREF="

http://msdn.microsoft.com/library/officedev/off2000/acdecShareDatabasesNetworkS.htm"

TARGET="_new">

http://msdn.microsoft.com/library/officedev/off2000/acdecShareDatabasesNetworkS.htm</A>

<p>nick bulka<br><a href=mailto: > </a><br><a href= > </a><br>

 

[falstaff]

Again - thanx for the response<br><br>I reckon I didn't know enough about LDB files ... now I think, thanx to both of you, I can<br><br>Humbled!<br><br>R

 

[moimoi]

It is probably because your access files reside on another machine than your web server. I had the same problem.<br>