Asp+access website FAQ and Solutions

First of all, I am learning PHP, but these two days have been modifying a asp+access website, encountered some problems, but also resolved, to share out to everyone.

Q1: Web site access is very slow, or sometimes it is OK, occasionally slow to die, or directly can not open

A1: These two days are always modifying Access database data, field types, etc., problems encountered. This problem, if the ASP's code is not a big problem, the most of the ten is access to the problem-solving method is as follows:

1. The server's anti-virus software firewall or what shut up try (no skip)

2. Upgrade access to 2007 or higher if possible (when you try to find access2007 less space than the access2000 database)

3. Compressing the database

4. You can delete some of the database logs, etc., or useless data.

5.access database if not required, use Memo fields as little as possible

6. Establish index and other optimization means

Q2: The second magic Problem encountered: The site front page can be normal browsing, all the data are read out, but the background to add articles, or modify anything, do not prompt errors, and prompted to add success, but the database is not

A2, I've been studying this question for several days. and Baidu and Google!! The last discovery is the database folder permissions problem! Do not give him the permission ya will not update the data! Pit Daddy!!

Q3: It's a magical question. The Site content page can be obtained by title, author, time, and so on, except that the Content field is not available. And the list page has an overview of the article to get to the content.

A3: This problem solved, but the problem does not know where, to a lot of ASP's friends did not see the solution, the final solution is in the output content of the time to query the database, and then direct output ...

If you are interested in friends can add a group of 252799167 pointers to me, common learning and progress!

This article is from the "尛 lei" blog, please be sure to keep this source http://a3147972.blog.51cto.com/2366547/1225915