I have a Site with lots of pictures. They come from an access database. The order of the pictures depends of the order in my database.
How can i change the order of records in my access database with Ultradev? I want to create a form where i can see all my datarecords. Then i will change the order of my records.

<font size=2>
Most Access Databases have the ID field as the primary key. I'm assuming that each time you submitted a record another unique ID was created and this is the sort order you are getting.

You could just add another number field, MYORDER and manually number them in the order you want them. then just do Select * from table SORT BY myorder ASC.





</font id=size2>

haa, so easy...
This will help me to finish my website.
Thanks a lot! <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>