Hello,
Does anyone have a utility or know where I can get a utility to convert a Access 97 MDB to a current version of Access MDB?
Thank you,
Conversion of access 97
- Rick Lipkin
- Posts: 2397
- Joined: Fri Oct 07, 2005 1:50 pm
- Location: Columbia, South Carolina USA
Re: Conversion of access 97
Darrell
Your best bet is to buy Office Pro 2007 or greater. When you open your old .Mdb in 2007 or greater .. you should be able to 'save as' to upgrade your old .mdb 97 to .mdb 2003. Stay with the .mdb format and not upgrade to .acctdb. AccDb will not work with MS Jet and you will have to add the Ms Ace OleDb to your distribution.
Rick Lipkin
ps .. you can also do the upgrade programatically .. create a new .mdb and then write a routine to append over the old data.
Your best bet is to buy Office Pro 2007 or greater. When you open your old .Mdb in 2007 or greater .. you should be able to 'save as' to upgrade your old .mdb 97 to .mdb 2003. Stay with the .mdb format and not upgrade to .acctdb. AccDb will not work with MS Jet and you will have to add the Ms Ace OleDb to your distribution.
Rick Lipkin
ps .. you can also do the upgrade programatically .. create a new .mdb and then write a routine to append over the old data.
Code: Select all
// create the adox object
Try
catNewDB := CreateObject("ADOX.Catalog")
Catch
MsgInfo( "Could not Create ADOX object")
oDLG:End()
Return(.f.)
End try
// create the table Vehicle.Mdb
Try
catNewDB:Create('Provider='+xProvider+';Data Source='+xSource+';Jet OLEDB:Engine Type=5;Jet OLEDB:Database Password='+xPASSWORD )
Catch
MsgInfo( "Could not create the table "+xSource )
oDLG:End()
Return(.f.)
End Try
cSay := "Created "+cDefa+"\Vehicle.Mdb"
oSay:ReFresh()
SysReFresh()
catNewDB:ActiveConnection:Close()
catNewDB := nil
SysWait(.5)