Sorting DAO Tables in VB

Hi...
I've got an application developen in VB using DAO to open Access Database file. My problem is how to sort the record sets when thy are opened as a Table. Indexes can not be used in Table mode!
LVL 1
progexAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
DhaestConnect With a Mentor Commented:
set data_rs = data_db.openrecordset("select * from tableName order by YourField", dbOpenDynaset)
0
 
DhaestCommented:
How do you assign your table to the dao-recordset ?
Otherwise you can give it a order by clause when you open your recordset:

rs.open "select * from yourTable order by YourField"
0
 
progexAuthor Commented:
well, i'm using the opendatabase function of the database object to open the recordset and set it to the record set object as follows:

set data_rs = data_db.opendatabase("database name", "table name, dbOpenTable)

no sorting option in here!!!
:(
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
progexAuthor Commented:
isn't there a method with the recordset object to reorder the table??
What about the sort methord of the recordset object???
0
 
DhaestCommented:
My recommandation: answered by Dhaest, because there was no reaction after my comment, so I guess that it the asker was satisfied about my comment.
0
All Courses

From novice to tech pro — start learning today.