is ajax faster than msaccess

i want to make my page faster. I have a data entry/look up page on the web..its msaccess mdb backend with just a asp.net page.

how can i get it so fast that it looks like a desk top app?

Ajax really is to improve the user's experience and make your web application more interactive. Instead of the screen flashing from postbacks and redrawing the entire web page you can use controls and update panels to prevent this, thus making your application appear more fluid and responsive.

http://en.wikipedia.org/wiki/Ajax_(programming)

http://msdn.microsoft.com/msdnmag/issues/06/07/atlasatlast/Note:It is now called ASP.NET AJAX.

http://www.w3schools.com/ajax/default.asp

is it faster when submiting databack to the database? no wait time?

AJAX doesn't change the speed of the underlying data store. If you're having trouble with the Access database running too slowly now, you'll have the same problems after adding AJAX.

so how would you match the speed of a desktop app ?

It depends on what exactly you're trying to do.

Is this an application you started with on the desktop and are moving to the web, or is it's already ASP.NET but slower than you'd like?

yes. its can access db that we want to put on the web

its access backend and slow to populate.

Try using the Cache to reduce the load on the database.

If it's large or very often in concurrent use, you should probably consider moving toward SQL Server if you can. Access is viable for small databases that don't have locking issues or high usage, but it doesn't scale well at all.

yes you are right..there are 80 users on the network at the same time

by the way do you know if ajax helps interms of speeding up sending get to the backend (sql server)

i am hoping that when a user post back to the sql system that the webpage would refresh itself and that it would take a second to update.

For all intents and purposes, AJAX will perform the same as regular ASP.NET. If your database is slow, that has to be addressed first.

i just made my boss buy a server and a copy of SQL server.. thanks

i have no idea how many cals we will need for 80 people

That'll be a good start. 80 users is pretty far beyond what I'd be comfortable using Access for.