Access97: Giving a report a db connection

  • Thread starter Thread starter Jonathan S via AccessMonster.com
  • Start date Start date
J

Jonathan S via AccessMonster.com

Is it possible to give a report a DB connection to use in getting its data? A
form may be updating data inside of a transaction and I would like to be able
to output a report with that data, without having to commit.

Is it possible to assign a RecordSet I construct with my own DB connection to
RecordSource? That might be one possible way to handle what I need to do.

Jonathan Scott
 
You can assign a Recordset in A2000 and later, but (from memory) I don't
think A97 could do that.

Options might be:

a) Write the records to to a temp table instead of a transaction, and then
(presumably after the user views the report and gives approval), to execute
an Append query statement to add them to the real table.

b) Write the records to the table, with a batch number that identifies them.
If the user doesn't like the result, delete all the records in the batch.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 
Back
Top