Hello all,
Over the past week I've spend countless hours scouring the internet, and trying to digest what I need to know to develop an Access FE application that will reside on the local machine, connect to "The Cloud" and still retain the ability to use VBA.
This is best of what I've found so far:
http://www.fmsinc.com/MicrosoftAccess/cloud/deploying-linked-azure-sql-databases.html
http://gainingaccess.net/SQLAzure/AccessAndSQLAzureInfo.aspx
I'm hoping as a community we can help each other learn and use this "hybrid" technology.
I still have many questions about this in general:
Any input would be greatly appreciated.
Admin, if we get enough good information, perhaps this is "Sticky" worthy?
Thanks Everyone!
Over the past week I've spend countless hours scouring the internet, and trying to digest what I need to know to develop an Access FE application that will reside on the local machine, connect to "The Cloud" and still retain the ability to use VBA.
This is best of what I've found so far:
http://www.fmsinc.com/MicrosoftAccess/cloud/deploying-linked-azure-sql-databases.html
http://gainingaccess.net/SQLAzure/AccessAndSQLAzureInfo.aspx
I'm hoping as a community we can help each other learn and use this "hybrid" technology.
I still have many questions about this in general:
- Is Azure's pricing competitive? What about performance?
- Is Azure the only option? What about other sites hosting SQL?
- AccessHosting.com seems to be another option, but I don't know what makes them different than any other hosting service
- How to handle roles within SQL or azure
- How best to obtain my users IP address and feed this back to the database security....Does this need to be manual or can it be programmed?
Any input would be greatly appreciated.
Admin, if we get enough good information, perhaps this is "Sticky" worthy?
Thanks Everyone!