Bizarro Column Order

[HenryE]

Hey Everyone,

I have an ADP linked to a SQL Server 2000 database. The odd thing is that in the main table, I can't make the Primary Key column the first column in the table's datasheet view. There used to be another primary key field and then I created this new primary key field, so maybe that has something to do with it. I also have a similar problem with trying to order the columns in Stored Procedures.

Can anyone explain why this is happening?

Thanks.

Henry

 

[smuckers]

Good Afternoon!

I can't explain why but I can tell you what I did to fix the problem. My Projects use stored procedures as much as possible and these problems occur from time to time when using Form-datasheet views. In this case, I open the form in Normal view and click on the column heading. Holding down the left mouse button, I drag it to the desired location on the datasheet.

Wait! You must now save with the column changed in this Normal view. Verify that it works by closing and re-opening the form. This has been the only way that I found it to work.

Good Luck!