I read that the following will make Access 2000, 2002 & 2003("Jet 4") .MDB usable by Access97 ("Jet 3"). Is that correct?
Moreover, what solutions are available for reading an Access 2003 table in Access97? FWIW, I only need tables right now. I comprehend that VBA may not survive the metamorphosis as "fully functional" as Data.[vba]Sub ConvertJetMDB()
dbName = "C:\path\olddb.MDB"
dbNewName = "C:\path\newdb.MDB"
Set dbdao = CreateObject("DAO.DBEngine.36")
MsgBox "DAO OK, version is " & dbdao.Version
dbver = 32
dbdao.CompactDatabase dbName, dbNewName, ";LANGID=0x0409;CP=1252;COUNTRY=0", dbver
Set newdb = dbdao.OpenDatabase(dbNewName)
MsgBox "Database opened OK - format version is " & newdb.Version
End Sub
[/vba]