I have developed small cms using dmx and access, on first page i wont to display data from 6 difrent tables, some recordsets hawe more complex sql.

Is it wrong to create 5 or 6 recordsets on that page all using same connection or there is other way for creating one recordes but more SQL views or something...