[AccessD] Access 2007 Ribbon Bar and accdb format

MartyConnelly martyconnelly at shaw.ca
Thu Jul 13 15:29:17 CDT 2006


Here is a sample 2007 accdb and method to program with VBA the
ribbon bar via xml inserted in a table. More convoluted
than command bars but at least everything is one place.

http://blogs.msdn.com/access/archive/2006/07/13/664757.aspx

By the way I had trouble converting an accdb back to 2000 format
You try to do a straight conversion and it squawks about
multi valued  fields or something and says can't do it.
I couldn't find the error or what it was complaining about.

Here is a way around it
Not too difficult to convert back from Access 2007
 just create a blank 2003 mdb and right click on the objects
and export them to the new blank mdb.
Selecting the database option.
You also have to recreate the table relationships structure.

To do multiple exports for tables or forms  via vba
use some variation of this

Sub testexport()
Dim cdb As Database 'Database to import
Dim td As TableDef 'Tabledefs in db
Dim strTDef As String 'Name of table or query to import
Set cdb = CurrentDb
'EXPORT tables from specified Access database
'keep opening through security squawk for each table
For Each td In cdb.TableDefs
strTDef = td.Name
Debug.Print strTDef
If Left(strTDef, 4) <> "MSys" Then
DoCmd.TransferDatabase acExport, "Microsoft Access", _
"C:\Access files\2007test\rebuild\crm2000.mdb", _
acTable, strTDef, strTDef, False
End If
Next
End Sub

-- 
Marty Connelly
Victoria, B.C.
Canada




More information about the AccessD mailing list