Hello friends.

This is mostly an "academic" question but I am curious if it is possible to have many copies of the access front-end (one for each user), the access backend for these users (or sqlserver or MySql) in a "Cloud Computing Technology", running Windows Server 2008 ?

For instance, when I install my software it uses the folder "c:\programfiles\My_Softaware". How am I supposed to have in the same cloud computer more different copies of my software since it is installed directly to that path (I am asking this because -perhaps- there is a way to avoid changing the installation path to c:\user\ ...)

Anyway, has anyone faced something similar or tried cloud computing with Ms Access ?

Thanks a lot ...

That's because just sticking your database tables onto a SQL Server doesn't take full advantage of SQL Server. You need to modify a bit of things, generally changing to pass-through queries and replacing large search functionality into a SP. This way you don't end up with the large amounts of data coming across the wire.