Select to view content in your preferred language

Manipulate MS Access Database in Silverlight

460
1
07-06-2011 01:01 PM
KeithGanzenmuller
Frequent Contributor
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.
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.
The database is on a server which is different from my ArcGIS Server.
Any suggestions on the best approach?
I have read some posts that claim to have done this, if you have could you give me some hints.
I have access to my SQL Server 2005 and of course the MS Access DB.
0 Kudos
1 Reply
JenniferNery
Esri Regular Contributor
You might want to use WCF service to access your database, there are some helpful forums about this from msdn website: http://social.msdn.microsoft.com/Forums/en/wcf/thread/bed4caa7-7c9e-4c66-a9da-e9c44c6bb547. You can also look at this blog post that explains how you can use WCF service with our API: http://blogs.esri.com/Dev/blogs/silverlightwpf/archive/2010/03/11/Sending-geometry-between-Silverlig...
0 Kudos