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
"Jon S via DotNetMonster.com" <u2272@uwe> wrote in message
news:578cc600d541e@uwe...
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.
--
Message posted via http://www.dotnetmonster.com