[dba-SQLServer] SQL Server Azure and MS Access 2010 and/or other better options

Darryl Collins darryl at whittleconsulting.com.au
Sun Aug 30 18:35:51 CDT 2015


Thanks folks for these suggestions.  Apologies for the sluggish reply - been off sick with a cold for the past few days.
Good approach too.  I forget we could use our own ISP which provides a similar set up to those suggested.

Cheers
Darryl.

-----Original Message-----
From: dba-SQLServer [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Scott Marcus
Sent: Wednesday, 26 August 2015 9:43 PM
To: 'Discussion concerning MS SQL Server'
Subject: Re: [dba-SQLServer] SQL Server Azure and MS Access 2010 and/or other better options

Darryl,

There are much cheaper options...

https://www.arvixe.com/

Don't get confused by the naming of their plans. PersonalClass, BusinessClass, ResellerClass are levels of service and not limits for what you can use them. The PersonalClass would most likely meet your needs.

You don't have to use the website portion of the hosting. Just use the MS SQL.

Scott Marcus

-----Original Message-----
From: dba-SQLServer [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Darryl Collins
Sent: Tuesday, August 25, 2015 9:24 PM
To: Discussion concerning MS SQL Server <dba-sqlserver at databaseadvisors.com>
Subject: [dba-SQLServer] SQL Server Azure and MS Access 2010 and/or other better options

Greetings People,

Given you are all way smarter and experienced in the world of SQL Server, I am going to ask your thoughts here.  Early days and I am looking for options.

In particular I was wondering if anyone has anyone has experience with using SQL Server Azure with a MS Access FE?
On the pricing of Azure, it seems you pay for every hour the DB exists, I am not sure how that works?  I mean, even if no-one access it for 2 weeks, I want it to 'exist' - or am I misunderstanding this whole SaaS thing?

Brief Big Picture:

Have multiple global users (about 20) who will need to log in occasionally (about once a week for a couple of hours) to update project forecasting data and view some bespoke reporting.  I have built this sort of thing before, but the SQL Server has always been in house and everyone who uses it on the same network.

The actual load and demand on the server will be tiny.  The SQL Server DB is mostly going to sit there doing bugger all and will spend a lot of time being a data store for reporting.

Azure appeals as it can be accessed from anywhere and Access 2010 (which we use) can hook right into it.

Frankly am happy to look at all options here.  Personally I would be happy to push the whole show out to an external provider (say something like <<http://www.workflowmax.com/>>) but the boss seems keen to keep the development in house.  Which is good for me (I will be doing this).

I can think of other potential options - Sharepoint might be one as well?

Thanks for your time
Cheers
Darryl.

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com


NOTICE:  This electronic mail transmission is for the use of the named individual or entity to which it is directed and may contain information that is privileged or confidential.  If you are not the intended recipient, any disclosure, copying, distribution or use of the contents of any information contained herein is prohibited.  If you have received this electronic mail transmission in error, delete it from your system without copying or forwarding it, and notify the sender of the error by replying via email or calling TSS Technologies at (513) 772-7000, so that our address record can be corrected.
Any information included in this email is provided on an "as is" and "where as" basis, and TSS Technologies makes no representations or warranties of any kind with respect to the completeness or accuracy of the information contained in this email.

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list