98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Re-organising table fields
Re-organising table fields
Resolved · Low Priority · Version Standard
Sat 23 Feb 2008, 21:17Delegate Mark said...
Mark has attended:
Access Intermediate course
Access Advanced course
Access VBA course
Re-organising table fields
I would like to revise the order that fields appear withn the design view of the main data table of a database in use. I know I can do this by manually dragging the fields, this is what I want to do. Is there possibly going to be any problem with operation of any queries (and forms based on those queries) or any other problem if I do this. I have tried it on small test database with no problem but would like more confidence with the big one (even though I would make a copy of the table first). This is a split databse incase that makes any difference.
Sat 23 Feb 2008, 21:29Trainer Rich said...
RE: Re-organising table fields
Changing the order of the columns will not affect any queries. As long as you do not change the name of the column or table then you will be fine. Nothing will ever relate to the ordering of the columns. Its always good to take backups, but you will be fine to do this.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Choosing data types in AccessNot sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field. |
