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.