My MS Access based ASP site stoped responding

Microsoft Access 2000/XP database is not designed to be used in multiuser server environment. Although Access database can function quite well as a back end for a small ASP site with low traffic, you are always run a risk of database corruption and concurrency issues.

Access databases are known to get corrupted when used under load. Typical symptoms of corrupted database are ASP page timeouts with out any specific error returned. In such case you must download your access database file, open it using appropriate version of Microsoft Access, and run "Compact and Repair". When finished repairing your database, upload your local repaired copy to the web server and overwrite the old one.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Is Microsoft Remote Data Services (RDS) supported?

DETAILS Microsoft Remote Data Services (RDS) is not supported.  RDS is a deprecated...

Do you support Data Access Page (DAP)?

DETAILS Data Access Page is not a supported feature.  Data Access Page is designed to be...

How can I secure my Access database on your servers?

You have a /db/ or a /data/ folder above the wwwroot folder so that your access database...

I receive error '80004005' when my ASP or ASP.NET code tries to insert into an Access Database. How do I resolve this?

SummaryWhen your ASP code tries to insert into an Access Database file, you receive one of the...