I have decided to use ms Access to develop my prototype mainly because I'm 

running out of time to learn about sql2000.But there there questions I 

would like to ask.Is it possible that the performance of my prototype 

slows down as my database gets larger?How slow?Does ms Access database 

corrupt easily?

Chye Ting, Hi;



Access has a compact (& repair) utility in the tools menu. You want to

run that if there seems to be a problem, and also periodically even when

there is no apparent problem.



Bear in mind that you can use Access in the so-called Access Data

Project mode in which you have the Access form and report development

environment and keep all your code in an access database but at the same

time connect to a SQL server database and keep all of the database

schema and database data and views and stored procedures and permissions

in SQL Server. Based on the questions you are asking, that is what you

want to do. You can read about it in the Access Developer help or the

MSDN library. You are stuck with Visual Basic for your form logic, but

if you can stomach that, then it is a very productive environment. You

can provide access to the application over the Internet using tsweb.



Lou Klauder



-----Original Message-----

From: Tan Chye Ting [mailto:chyeting18@h...] 

Sent: Sunday, December 09, 2001 9:43 AM

To: ASPToday Discuss

Subject: [asptoday_discuss] Doubts on ms Access performance



I have decided to use ms Access to develop my prototype mainly because

I'm 

running out of time to learn about sql2000.But there there questions I 

would like to ask.Is it possible that the performance of my prototype 

slows down as my database gets larger?How slow?Does ms Access database 

corrupt easily?