Urgent help regarding a web development project.

[cingo]

Dear all,

I need urgent help regarding a web development project.
I would be very pleased if you can guide me in this regard.

My requirement is as follows.

i need to have a web based project that should also work offline. (also using a website)
its just a small (but sensitive) database of say 100-200 fields and has attachment links to the files that are uploaded on a server.

both online and offline versions have same functionality and modules
all forms same! (can it be just one downloadable software with online-offline modes? to access database? )

end users -- around 50, located anywhere

software when online:
1. the latest database should be download, according to user privileges, locally and should be very secure that no one can open it using tools other than the software. it must also be encrypted? (how?)
2. the local changes that i save in the software should be syncronized to the online database. (how?)
3. core software for report generation etc.

software when offline:
1. according to user privileges, locally i can view/use the downloaded offline data without internet connection.
2. i should be able to save local new records/changes that i add in the software (can be done in a temporary database for syncronization)
3. ?data must be encrypted
4. offline software for report generation etc.

questions:

what is the ideal SERVER side programing language for such a dev project? ASP.NET, VB.NET, PHP, JSP ???
what is the ideal CLIENT side programing language for such a dev project?
what should the ONLINE database and OFFLINE database backend be? MYSQL, MSSQL, ACCESS ???

how should the general structure of callbacks and serverside and clientside software be?
can AJAX help? (like ComponentArt GUI)
are there any third party tools that make working with online-offline apps easier?
how to have minimum fuss for the end user (no complex installations/ no webservers running etc)

how should one secure such apps? locally and online?
also is decompiling such apps possible? how will i know?

--- I WILL BE VERY THANKFUL IF ANYONE CAN GUIDE ME -----

i was planning on using ASP.NET with mysql.....but i dont know about the offline version!


THANKS AND REGARDS

CINGO S.

[Orjan]

Server language is more a question of taste. ASP.NET or PHP would be the primary choices I think.

The ONLINE database could be anything, MySQL is available on several platforms, Access & MS-SQL is both pay-software and only windows platform.

the offline version sounds like you would like an application. if it's windows only, and money for access is available, sure, otherwise, maybe an java application which is both cross-platform and free.

I suggest that you create an application with the online and offline possibilities in one app, and then java would suit. with this, you wouldn't really need much of a online server thing either, only something to provide data access to the application.

[cingo]

I suggest that you create an application with the online and offline possibilities in one app, and then java would suit. with this, you wouldn't really need much of a online server thing either, only something to provide data access to the application.

Thanks orjan

can u guide me more about the
"application with the online and offline possibilities in one app, and then java would suit. "

what should be the java tools to be used?
jsp? or what?
some more details please....

i will prefer a mysql backend.

how can i run client side local database?