Gustav Brock
gustav at cactus.dk
Wed Nov 5 15:33:39 CST 2014
Hi Shamil I haven't done so but it looks interesting as the web based Access apps are so limited. This could be the best of both worlds regarding Access desktop applications. A simpler option is, of course and also noted in one of the comments to the article, to use a "clean" SQL Server account on Azure. By the way, can an existing database from a normal SQL Server be exported to SharePoint for the use as the backend to an Access desktop frontend? /gustav ________________________________________ Fra: accessd-bounces at databaseadvisors.com <accessd-bounces at databaseadvisors.com> på vegne af Salakhetdinov Shamil <mcp2004 at mail.ru> Sendt: 5. november 2014 21:01 Til: Access Developers discussion and problem solving Emne: [AccessD] Article: "How to ‘Hybridize’ your MS Access Database In Office 365 Azure Database" Hi All -- Does anybody use "hybrid" MS Access FE/SQL Azure BE (Office 365) applications in production? "How to ‘Hybridize’ your MS Access Database In Office 365 Azure Database" http://www.devhut.net/2014/01/13/how-to-hybridize-your-ms-access-database-in-office-365-azure-database/ I have just followed the referred article's instructions using my Office 365 dev account and I have got a sample "hybrid" database up& running. And MS Access 2013 .accdb bound forms have read-write access to the linked via 'ODBC;DRIVER=SQL Server Native Client 11.0;' SQL Azure database tables. I wonder if such .accdb forms can be bound to SQL Azure insert/update/delete stored procedures? FYI: Here is a good set of information on SQL Azure and MS Access: http://gainingaccess.net/SQLAzure/AccessAndSQLAzureLinks.aspx Thank you. -- Салахетдинов Шамиль