• RSS
  • Twitter
  • FaceBook

Security Forums

Log in

FAQ | Search | Usergroups | Profile | Register | RSS | Posting Guidelines | Recent Posts

MS Access sorting problems

Users browsing this topic:0 Security Fans, 0 Stealth Security Fans
Registered Security Fans: None
Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Databases

View previous topic :: View next topic  
Author Message
jf0027
Just Arrived
Just Arrived


Joined: 07 Jul 2005
Posts: 0


Offline

PostPosted: Tue Oct 10, 2006 5:01 pm    Post subject: MS Access sorting problems Reply with quote

Hi, i need to sort a table in access and nothing seems to work so far. Here's the deal. I have a delimited text file that i import to a table. That file is not sorted. What i want to do is sort the table to make modification later. The thing is i want to use VBA coding to do this. So far, the DAO Recordset sort method did not work. I can select a sorted table from the original one, but i dont know how to apply it over the original.

Any ideas?
Back to top
View user's profile Send private message
larsmhansen
Trusted SF Member
Trusted SF Member


Joined: 11 Jan 2003
Posts: 0
Location: Boston, MA, USA

Offline

PostPosted: Tue Oct 10, 2006 6:13 pm    Post subject: Reply with quote

You cannot sort tables in Access. Records always remain in the same order as they were entered. You can temporarily apply a sort to view the record in the order of your choice, but you cannot actually re-order the order of the records.

And, now to contradict myself, you can sort a table in Access, but it takes some work. Essentially, you need to create a query that takes the original data, sorts in to your needs and then puts this data into a new table. The new table will then be "sorted". Delete the old table, and rename the new...
Back to top
View user's profile Send private message Send e-mail Visit poster's website MSN Messenger
jf0027
Just Arrived
Just Arrived


Joined: 07 Jul 2005
Posts: 0


Offline

PostPosted: Thu Oct 19, 2006 6:39 pm    Post subject: Reply with quote

Thanks. I convince my teamate that it wasn't necessary that the table had to be physically sorted. So i only applied the "select order by" statement, did what i needed to do on the table and it worked.
Back to top
View user's profile Send private message
Display posts from previous:   

Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Databases All times are GMT + 2 Hours
Page 1 of 1


 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Community Area

Log in | Register