By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,395 Members | 2,505 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,395 IT Pros & Developers. It's quick & easy.

How to convert an Access.mdb format???

P: n/a
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
Nov 18 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"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

Nov 18 '05 #2

P: n/a
...

--
Message posted via DotNetMonster.com
http://www.dotnetmonster.com/Uwe/For...sharp/200511/1
Nov 18 '05 #3

P: n/a
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

Nov 18 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.