problem of using ACCESS

  • Thread starter Thread starter Shao Yong
  • Start date Start date
S

Shao Yong

I've written an asp.net application using ACCESS as the database. It
works well first. But after a while, I found the application cound not
make response to user's request quickly. It seems dead. You couldn't the
ASP.NET page.

Why? And how to solve the problem. Someone please help me.

Here are something about the application:
1. the debug mode has been turned off in the web.config
2. I close opened connections it after I used.
3. I write a class for handling general operation to the ACCESS database
like query, insert, update etc. And the all static methods.
 
Shao Yong said:
I've written an asp.net application using ACCESS as the database. It
works well first. But after a while, I found the application cound not
make response to user's request quickly. It seems dead. You couldn't the
ASP.NET page.

Why? And how to solve the problem. Someone please help me.

Here are something about the application:
1. the debug mode has been turned off in the web.config
2. I close opened connections it after I used.
3. I write a class for handling general operation to the ACCESS database
like query, insert, update etc. And the all static methods.
Click to expand...

Can you give us some information on how big the database has become (numbers
of tables and rows in each), and how many concurrent users there are? On the
surface, it sounds like a scalability issue.
 
Oh, the database is pretty small, it's a for contact directory. The
Access database only contains tree tables, and hundreds of rows in
total. And only a few concurrent users.

I think, maybe it's a problem the server or the application itself(code)¡£
 
Shao Yong said:
.... And only a few concurrent users.
Click to expand...
Use MSDE and or SQL Express (still beta). MS/ACCESS is a desktop DB, not
designed for multi-users environment, neither designed to work with a web
server. On top of this, it is not secure! However, if your client insists on
using it, tell them no more than 5 concurrent users.

John
 
Back
Top