How to convert an Access.mdb format???

  • Thread starter Thread starter Jon S via DotNetMonster.com
  • Start date Start date
J

Jon S via DotNetMonster.com

Hi all,

Is there a way to convert an Access.mdb from one format (say Access '97 or
Access 2000) to Access 2002 format using ADO.NET and C#??? I know how to do
it manually using the Access DBMS but I would like to know how to do it
programatically.

I don't have any idea if this can be done so if it can please could someone
show the code to do it or provide links so I can read up on how to do it.

Thanks in advance.
 
Jon,

I don't believe there is a way to do it through ADO.NET. ADO.NET is
good at exposing the common functionality that most data stores expose
(select, update, delete, insert), not at performing specific DB functions.

In order to do this, you would be better off automating access and
performing the operation through there.

Hope this helps.
 
Hi Jon,

First, you need to understand that you don't really "convert" an Access mdb.
You create a new Access mdb with the format desired, and put everything from
the first into the second. The tricky part is not moving the data; it's
anything else you may expect to move over. For example, an Access mdb file
may contain, in addition to data, relationsips, and indices, Reports,
Modules, Forms, and other items which are not directly related to data. If
you want to migrate these over, your task will be much more difficult, as
functionality available in one version may not be available in the other,
may need to work slightly differently, etc. In other words, you need to
identify exactly what you want to "convert" to the other database. Anything
that is purely database-related can easily be copied/tranformed. Anything
else is going to be, at best, problematic.

To do this programmatically, you would need to create instances of both
database applications using their COM programming interface. This would, of
course, require COM interop. From there, it is more or less a relatively
simple matter of using the COM interface, combined perhaps with .Net
database classes, to copy the database data, etc.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
If you push something hard enough,
it will fall over.
- Fudd's First Law of Opposition
 
Back
Top