| 9:28 pm on Aug 30, 2005 (gmt 0)|
Does the Internet Guest Account (IUSR_Something) have appropriate rights to the directory containing the database?
| 9:44 pm on Aug 30, 2005 (gmt 0)|
CHMOD is 777 in that directory. I assume this is the right settings?
| 12:29 am on Aug 31, 2005 (gmt 0)|
Don't use access for web work. Access is fine for a desktop app, but not the constant open and close of the web.
use mySql or mssql instead.
| 1:20 pm on Aug 31, 2005 (gmt 0)|
|Don't use access for web work |
Actually, in my experience, using Access is just fine for light to medium loads... But when you start getting a heavy load, you should certainly consider something like MS SQL Server!
| 3:09 pm on Aug 31, 2005 (gmt 0)|
Its normal for the .ldb file to be locked when the database is open.
Sounds like the conenction isnt being released properly - are you closing the recordset before releasing it? What error message do you get?
| 9:10 pm on Sep 11, 2005 (gmt 0)|
Access has many problems in a hosted environment and the locked file syndrome is one of the more common.
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.
| 2:28 pm on Sep 16, 2005 (gmt 0)|
Access, in my ISP environment, perfectly support concurrent connections...