pskeens
asked on
MS SQL hosting for Access Front End
I am looking for a MS SQL 2008 (preferrable R2) database. I have looked and read through many many reviews but would like the opinions of you professionals.
Basically the front end will be MS Access and connect through ODBC to my hosted DB. One step further I am looking at Sharepoint hosting for some of the Access web forms (2010), but the DB is the most important part as of now.
I have looked very close at 1&1, WebHost4Life, ServerMart and a couple others. These three stand out to me the most but what is your opinions? Thanks in advance.
Basically the front end will be MS Access and connect through ODBC to my hosted DB. One step further I am looking at Sharepoint hosting for some of the Access web forms (2010), but the DB is the most important part as of now.
I have looked very close at 1&1, WebHost4Life, ServerMart and a couple others. These three stand out to me the most but what is your opinions? Thanks in advance.
dqmq
I have to question whether you will get acceptable performance with the FE-BE connection at WAN speeds. You may be hosting the Access web forms sooner than you think.
ASKER
I have done it before and performance was pretty good. THis is one reason I want a good host with good performance and stability.
If you want an enlightened advice about how a hosted SQL Server database would perform using an Access Front end, you must to provide more details about connectivity, network bandwidth and host database size. You also need to provide us with information as to how many people will be using the database front end.
If on the other hand, you already made up your mind onto the solution and simply want us to provide you with a good host for SQL Server, then the question seems to have been already answered.
If on the other hand, you already made up your mind onto the solution and simply want us to provide you with a good host for SQL Server, then the question seems to have been already answered.
<<I have done it before and performance was pretty good. >>
Some words of caution: the fact that you had good performance by using the system by yourself does not mean you will get good performance if many people connect at the same time. Sorry but that is the way SQL Server works.
Hope this helps...
Some words of caution: the fact that you had good performance by using the system by yourself does not mean you will get good performance if many people connect at the same time. Sorry but that is the way SQL Server works.
Hope this helps...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@ArmenStein>
Some very good and relevant comments. I do concur...
The proposed configuration does not scale well and does not migrate to Sharepoint Access Services without abandoning SQL Server. If the backend is SQL Server hosted over a WAN connection, then you need a middle tier that's also hosted such that you can get much higher bandwidth between the application and the data.
Some very good and relevant comments. I do concur...
The proposed configuration does not scale well and does not migrate to Sharepoint Access Services without abandoning SQL Server. If the backend is SQL Server hosted over a WAN connection, then you need a middle tier that's also hosted such that you can get much higher bandwidth between the application and the data.
ASKER
dgmg
What are you referring to as a middle tier?
I have it hosted now over WAN and the performance is good for development. Yes this will differ when I get concurrent users but we are only talking about 5-8 concurrent users at the same time maximum. On average it will be 2-3 I would imagine for now.
The future plan is to move it all in house but I have to get it running for now.
What are you referring to as a middle tier?
I have it hosted now over WAN and the performance is good for development. Yes this will differ when I get concurrent users but we are only talking about 5-8 concurrent users at the same time maximum. On average it will be 2-3 I would imagine for now.
The future plan is to move it all in house but I have to get it running for now.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.