topic Re: Manipulate MS Access Database in Silverlight in ArcGIS API for Silverlight Questions https://community.esri.com/t5/arcgis-api-for-silverlight-questions/manipulate-ms-access-database-in-silverlight/m-p/70263#M1734 <HTML><HEAD></HEAD><BODY><SPAN>You might want to use WCF service to access your database, there are some helpful forums about this from msdn website: </SPAN><A href="http://social.msdn.microsoft.com/Forums/en/wcf/thread/bed4caa7-7c9e-4c66-a9da-e9c44c6bb547">http://social.msdn.microsoft.com/Forums/en/wcf/thread/bed4caa7-7c9e-4c66-a9da-e9c44c6bb547</A><SPAN>. You can also look at this blog post that explains how you can use WCF service with our API: </SPAN><A href="http://blogs.esri.com/Dev/blogs/silverlightwpf/archive/2010/03/11/Sending-geometry-between-Silverlight-and-the-server-using-WCF.aspx">http://blogs.esri.com/Dev/blogs/silverlightwpf/archive/2010/03/11/Sending-geometry-between-Silverlight-and-the-server-using-WCF.aspx</A></BODY></HTML> Fri, 15 Jul 2011 22:29:16 GMT JenniferNery 2011-07-15T22:29:16Z Manipulate MS Access Database in Silverlight https://community.esri.com/t5/arcgis-api-for-silverlight-questions/manipulate-ms-access-database-in-silverlight/m-p/70262#M1733 <HTML><HEAD></HEAD><BODY><SPAN>We have a MS Access database that is used to track code violations and notifications. The database is in widespread use, it has dozens of forms and modules so it really isn't practical in the short-term to move the database to SQL Server.</SPAN><BR /><SPAN>I need access to the database in my Silverlight project, actually for the time being I need access to one table in the database but it needs to be the current version of that table. At the moment I could live with a read-only connection but may need to write to it eventually. </SPAN><BR /><SPAN>The database is on a server which is different from my ArcGIS Server. </SPAN><BR /><SPAN>Any suggestions on the best approach?</SPAN><BR /><SPAN>I have read some posts that claim to have done this, if you have could you give me some hints. </SPAN><BR /><SPAN>I have access to my SQL Server 2005 and of course the MS Access DB.</SPAN></BODY></HTML> Wed, 06 Jul 2011 20:01:25 GMT https://community.esri.com/t5/arcgis-api-for-silverlight-questions/manipulate-ms-access-database-in-silverlight/m-p/70262#M1733 KeithGanzenmuller 2011-07-06T20:01:25Z Re: Manipulate MS Access Database in Silverlight https://community.esri.com/t5/arcgis-api-for-silverlight-questions/manipulate-ms-access-database-in-silverlight/m-p/70263#M1734 <HTML><HEAD></HEAD><BODY><SPAN>You might want to use WCF service to access your database, there are some helpful forums about this from msdn website: </SPAN><A href="http://social.msdn.microsoft.com/Forums/en/wcf/thread/bed4caa7-7c9e-4c66-a9da-e9c44c6bb547">http://social.msdn.microsoft.com/Forums/en/wcf/thread/bed4caa7-7c9e-4c66-a9da-e9c44c6bb547</A><SPAN>. You can also look at this blog post that explains how you can use WCF service with our API: </SPAN><A href="http://blogs.esri.com/Dev/blogs/silverlightwpf/archive/2010/03/11/Sending-geometry-between-Silverlight-and-the-server-using-WCF.aspx">http://blogs.esri.com/Dev/blogs/silverlightwpf/archive/2010/03/11/Sending-geometry-between-Silverlight-and-the-server-using-WCF.aspx</A></BODY></HTML> Fri, 15 Jul 2011 22:29:16 GMT https://community.esri.com/t5/arcgis-api-for-silverlight-questions/manipulate-ms-access-database-in-silverlight/m-p/70263#M1734 JenniferNery 2011-07-15T22:29:16Z