Posted by Razvan Socol on 09/02/06 08:19

It is indeed an MS Access problem (specific to ADP-s). You can reorder
the columns in the resulting datasheet freely and Access remembers the
position and width of the columns when you open the table/view/function
again. Access usually asks "Do you want to save changes to the layout
of function '...' ?". If you respond "yes", it stores this information
in the database, using extended properties for the objects and for the
columns.

Razvan

• Next in forum: Re: How do you create ##Temp tables if they don't exist, use them if they do?
• Prev in forum: Restore Messed Up Table Names
• Thread view: Re: Column order/presentation in virtual table (result set from view or UDF)

[Reply to this message]