With an ADO recordset you could try to append a new field to the adoRS and then find a way to pass the recordset to your report. Or use a disconnected adoRS for your application, this may be better.
' Dimension your Connection and Recordset
Dim adoConn as Adodb.Connection
Dim adoRS as Adodb.Recordset
' Create your connection
Set adoConn = new adodb.connection
with adoConn
.Provider = "Microsoft.Jet.OLEDB.3.51"
.ConnectionString = "data source=<filepath to mdb>"
.Mode=adModeRead
.Open
end with
' Create your recordset
set adoRS = new adodb.recordset
adoRS.CursorLocation = adUseClient
adoRs.Open "<Table Name>", adoConn
' Kill any persisted dataset already out there.
' Sample: "c:\access\saccess.dat"
Kill "<path to save recordset to>"
' Save the recordset to a file.
' Sample: "c:\access\saccess.dat"
adoRS.Save "<path to saved recordset>", adPersistADTG
' Now you have the recordset local and you can do with it
' what you wish.
' Open the saved recordset as a file
adoRS.Open "<path to saved recordset>",,,adCmdFile
' What you do next is up to you.
' Modify your data, load into a flexgrid, etc...
' If you happened to want to return the changes to the
' original database you could use adoRS.UpdateBatch command
' You will need to look that up yourself though.