Hello friend

,
I haven't tested the following code (network settings here don't allow creating objects on the server, can you believe it...). I hope it works and this is what you mean.
<CFSCRIPT>
MyConn = CreateObject("COM", "ADODB.Connection"

DSNtemp = "DRIVER={Microsoft Access Driver (*.mdb)};"
DSNtemp = DSNtemp & "DBQ=e:\data\myDatabase.mdb"
MyConn.Open("#DSNtemp#", "Username", "Password", -1)
SQL = "SELECT * FROM table"
MyRecordset = MyConnection.Execute(SQL, 0, 8);
MyFields = MyRecordset.Fields;
/* Make a variable for recordcount */
RecordCount = 0;
while(NOT MyRecordset.EOF){
RecordCount = RecordCount + 1;
MyRecordset.MoveNext();
}
Columns = "";
</CFSCRIPT>
<!--- Get the Column Name from the MyFields collections --->
<CFLOOP COLLECTION="#MyFields#" ITEM="this">
<CFSET Columns = ListAppend(Columns, this.Name)>
</CFLOOP>
<!--- Populate a newly made query with columns --->
<CFSET MyRecords = QueryNew(Columns)>
<!--- Add 'RecordCount' rows to hold the data --->
<CFSET QueryAddRow(MyRecords, RecordCount)>
<!--- Go to the first row of the recordset --->
<CFSET MyRecordset.MoveFirst()>
<!--- And populate the recordset... --->
<CFLOOP FROM="1" TO="#RecordCount#" INDEX="i">
<CFLOOP COLLECTION="#MyFields#" ITEM="this">
<CFSET QuerySetCell(MyRecords, Trim(this.name), this.value, i)>
</CFLOOP>
<CFSET MyRecordset.MoveNext()>
</CFLOOP>
<!--- Ouput the data like this: --->
<CFOUTPUT QUERY="MyRecords">
<TR>
<CFLOOP LIST="#MyRecords.ColumnList#" INDEX="this">
<TD>#Evaluate(this)#</TD>
</CFLOOP>
</TR>
</CFOUTPUT>
</TABLE>
<!--- Close the ODBC connection (like you do in ASP)--->
<CFSET MyConnection.Close()>
Pretty impressive huh? If it doesn't work, don't get mad, and if it works, don't expect a great performance. CFQUERY is at least twice as fast, but hey, you've got a DSNless connection now, right

.
Good luck.
<webguru>iqof188</webguru>