Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 ( however access works only with ADO the old technology.

But the application works! And it updates the SQL databases. So how does this works?

share|improve this question

closed as off-topic by masegaloeh, kasperd, Jenny D, HBruijn Sep 28 '15 at 16:39

This question appears to be off-topic. The users who voted to close gave these specific reasons:

If this question can be reworded to fit the rules in the help center, please edit the question.

This looks suspiciously "Stack Overflow"-esque to me. – Evan Anderson Jun 18 '09 at 15:05
up vote 1 down vote accepted

Evan's right, you'll probably get much better results from this on StackOverflow.

That said, you're partially right. Internally Access only works with the original ADO because it uses VBA. Since VBA only has support for COM you're only going to get classic ADO support in your macros and internal code.

Connecting to an external datasource is a bit different in that you can use other drivers to do this. More than likely you're connecting to SQL 2008 with the .NET Sql Native Client or a SQL OLEDB driver.

share|improve this answer

Do you mean that the migration wizard has not only migrated the data to sql server, but also updated the mdb file to use that sql server database instead of its own tables? And you are wondering how that works?

I am not sure how the migration wizard sets this up, but I have done this manually before, and I did it with linked tables. After all the data is migrated to sql server, I removed all the tables from the mdb file and replaced each of them with a linked table to their equivalent table in sql server..

share|improve this answer
that what i did, exactly, but what technology does that uses? – Omar Abid Jun 18 '09 at 16:49
Linked tables use ODBC under the hood, but that's totally transparent. – fretje Jun 18 '09 at 19:57

Not the answer you're looking for? Browse other questions tagged or ask your own question.