Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: open
An LDB locked file is produced by Access on the server once the page connects to the database (using a Jet DSNless connection), which didn't happen with our old ISP. This locks everyone else out, and the server hangs, making our site inaccessible:
conn.Open "Data Source=" & Server.Mappath("/path-to-data.mdb") & ";Provider=Microsoft.Jet.OLEDB.4.0;"
I've pulled out clumps of hair over the last 72 hours trying to sort this out. If anyone can help me to keep the remaining strands of hair, I'd be very grateful.
Because Microsoft MSDE is free for both hosting companies and end-users, there really is no reason to not use a real database (MSDE) instead of the file-based MS Access.
If your hosting company can't support MSDE, and you don't want to upgrade to a full SQL Server account, then go somewhere else.
All medium to large (but not small) Microsoft technology hosting companies support database hosting as it is the foundation for ASP, ASP.NET, SharePoint and most of the Microsoft Server stack.