I'm trying to open an ADO recordset of an Access table that is sorted/ordered by the Table's OrderBy property but I can't seem to find how to read a Table's OrderBy Property in ADO or ADOX. I can do it with DAO:
dim db as dao.database
dim tdf as dao.tabledef
set db=Currentdb()
set tdf=db("TheTable"
Debug.Print tdf.Properties("ORDERBY"
but it takes about 6 seconds to return the answer.
Does anyone know how to read a Table's OrderBy property more quickly.
Thanks!
dftjsn
dim db as dao.database
dim tdf as dao.tabledef
set db=Currentdb()
set tdf=db("TheTable"
Debug.Print tdf.Properties("ORDERBY"
but it takes about 6 seconds to return the answer.
Does anyone know how to read a Table's OrderBy property more quickly.
Thanks!
dftjsn