Converting Access97 to Access2000 with DAO3.6 using VB6

I currently have an program which is used on over 200 sites. This program was using Access97 which has performed perfectly, I have decided to upgrade my DBMS to Access2000 and need to know how to upgrade the existing databases from within vb.I am using DAO 3.6.
Is this the code to convert the existing MDB's ?

private sub Convert()
Dim DbCompact As New DBEngine
DBEngine.CompactDatabase "C:\Status1.mdb", , "C:\Status.mdb", dbLangGeneral, dbversion30
end sub

When I execute this code and open the mdb in Access2000 I am still prompted "Convert Database" ,so i persume that the database was not converted

I must be doing somethin wrong !
Any Ideas????

turloughmAsked:
Who is Participating?
 
kodiakbearConnect With a Mentor Commented:
Per Recommendation

kb
Experts Exchange Moderator
0
 
TimCotteeCommented:
Close, dbVersion30 creates a DAO 3/3.5 compatible database (i.e., Access 97) use dbVersion40 for DAO 3.6 compatible or access 2000.
0
 
manchandaCommented:
try this command:


application.ConvertAccessProject"db8.mdb","db9.mdb",acFileFormatAccess2000
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
turloughmAuthor Commented:
What references do I use with application.ConvertAccessProject"db8.mdb","db9.mdb",acFileFormatAccess2000

0
 
manchandaCommented:
actually i tried this way:

Private Sub Command1_Click()
Dim app As Object
'Const acFileFormatAccess2002 = 10
Set app = CreateObject("Access.Application.10")
app.ConvertAccessProject "c:\db9.mdb", "c:\db11.mdb", 10
End Sub
0
 
CleanupPingCommented:
turloughm:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
 
DanRollinsCommented:
turloughm, an EE Moderator will handle this for you.
Moderator, my recommended disposition is:

    Save as PAQ -- No Refund.

DanRollins -- EE database cleanup volunteer
0
All Courses

From novice to tech pro — start learning today.