I haven't found a way to do this well. If you haven't put the data in yet, then you can just right-click on the table name and choose Edit and retype the names and data types in design view. However, if you do this once data has been entered, everything is undone once you save and the table goes back to the way it was.
You might consider making a view or query of the table, with the fields in the order you want. Or export the table to a spreadsheet, rearrange the data in the spreadsheet, then bring the spreadsheet back into the database as a new table and delete the old one.
Dig Deeper on Open source databases
Related Q&A from Solveig Haugland
Our expert tells you how to use search to find strings in OpenOffice.org's Calc.continue reading
An office suite expert describes how to use ODBC with OpenOffice 2.0.continue reading
An office suite expert describes where to find information on OpenOffice 2.0's use in the enterprise worldwide.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.