My company (I work for) has a Microsoft Office access application, it's more than 1 million line of code and hundred of forms, tables, databases. So converting it to dot net (my suggestion) isn't a choice for my boss.
The aim is to migrate it to SQL Server, I have done simple SQL migration and tables had been converted and everything alright, but I'm using SQL 2008, which (should) implement the "disconnect" technology (ado.net) however access works only with ADO the old technology.
But the application works! And it updates the SQL databases. So how does this works?