Convert ACC97 to ACC2000 using VB and DAO or ADO? 
Author Message
 Convert ACC97 to ACC2000 using VB and DAO or ADO?

Suggestions anyone?

best regards
m



Fri, 04 Jul 2003 23:57:30 GMT  
 Convert ACC97 to ACC2000 using VB and DAO or ADO?
I would guess that the Access2000 is required. Or, if you have the spec on
the Acc97 and Acc2000 file formats, you might be able to write your own
converter in VB. Seems like a lot of work.

 - Tom

Quote:

> Suggestions anyone?

> best regards
> m



Sat, 05 Jul 2003 00:17:38 GMT  
 Convert ACC97 to ACC2000 using VB and DAO or ADO?


Quote:
> Suggestions anyone?

> best regards
> m

If your goal is to convert your Access97 (Jet 3.5) to the Access2000 format
(Jet 4,0), then there is a way.

Make sure you clicked the "Microsoft Jet and Replication Objects 2.1
Library" in the References window.

    Dim MyJRo As JRO.JetEngine

    MyJRo.CompactDatabase "Provider=Microsoft.Jet.4.0;" & _
                            "Data Source=c:\olddata.mdb;", _
                            "Provider=Microsoft.Jet.4.0;" & _
                            "Data Source=c:\newdata.mdb" & _
                            "Jet OLEDB:Engine Type=5"

This takes care of the dataformat that the JET engine uses, but does not
convert any Access stuff like macros, reports  and so on.

If your database is an Access application, use Access 2000 for the
conversion.

Tord



Sat, 05 Jul 2003 05:22:10 GMT  
 Convert ACC97 to ACC2000 using VB and DAO or ADO?
Thanks Tord,

The code seems logical (you need to declare a new instance of the object
before using compactdatabase) but when i run the code recive an automation
error (-2147221164 Class not registered)..

I've searched the KB but could'nt find a explaination of the problem..

So what the heck is this?? A bug? A problem? A brain meltdown?

I run the code on Win2k, MDAC 2.6 and JET4 SP3

Best regards
m


Quote:


> > Suggestions anyone?

> > best regards
> > m

> If your goal is to convert your Access97 (Jet 3.5) to the Access2000
format
> (Jet 4,0), then there is a way.

> Make sure you clicked the "Microsoft Jet and Replication Objects 2.1
> Library" in the References window.

>     Dim MyJRo As JRO.JetEngine

>     MyJRo.CompactDatabase "Provider=Microsoft.Jet.4.0;" & _
>                             "Data Source=c:\olddata.mdb;", _
>                             "Provider=Microsoft.Jet.4.0;" & _
>                             "Data Source=c:\newdata.mdb" & _
>                             "Jet OLEDB:Engine Type=5"

> This takes care of the dataformat that the JET engine uses, but does not
> convert any Access stuff like macros, reports  and so on.

> If your database is an Access application, use Access 2000 for the
> conversion.

> Tord



Sat, 05 Jul 2003 17:47:20 GMT  
 Convert ACC97 to ACC2000 using VB and DAO or ADO?


Quote:
> Thanks Tord,

> The code seems logical (you need to declare a new instance of the object
> before using compactdatabase) but when i run the code recive an automation
> error (-2147221164 Class not registered)..

> I've searched the KB but could'nt find a explaination of the problem..

> So what the heck is this?? A bug? A problem? A brain meltdown?

> I run the code on Win2k, MDAC 2.6 and JET4 SP3

I'm sorry. I wrote the code on the fly without testing it... The provider
string is false and you have to initiate the MyJRo object varible...

use this instead..

    Dim MyJRo As JRO.JetEngine

    Set MyJRo = New JRO.JetEngine

    MyJRo.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                            "Data Source=c:\olddata.mdb;", _
                            "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                            "Data Source=c:\newdata.mdb;" & _
                            "Jet OLEDB:Engine Type=5"

Tord



Mon, 07 Jul 2003 05:21:52 GMT  
 
 [ 5 post ] 

 Relevant Pages 

1. Problems Convert Acc97 to Acc2000

2. Converting db from Acc2000 to Acc97

3. create DB in acc2000 and open in acc97

4. help converting vb app from dao to ado

5. Converting JET 3.51(97) To Jet 4.0(2000) Using DAO In VB 5

6. Err 3633 using VB 6 and Acc2000

7. Converting ADO to DAO

8. Converting from DAO to ADO SQL

9. Convert DAO to ADO

10. Creating a DB - Converting DAO to ADO

11. Convert DAO to ADO

12. Problem converting DAO -> ADO

 

 
Powered by phpBB® Forum Software