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
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 !