N
N. Cotton
I am trying to create a report which is generated from records in identical
tables from multiple backends.
For example, a report of employee names which is the complete list of every
employee name in numerous backends.
I can do it the long winded way by connecting to each backend via
Set db = DBEngine.Workspaces(0).OpenDatabase(strdbName) etc ...
then looping through each applicable recordset and adding each record to a
local a temp table in the current backend.
I am pretty sure there must be a way to create the table using SQL INSERT
INTO for example SELECT tblemployee.* INTO tblemployees IN 'temp.mdb' but I
would ideally like to do it without having to relink to each backend.
Does anyone have any ideas or is there a better way to achive this?
many thanks.
tables from multiple backends.
For example, a report of employee names which is the complete list of every
employee name in numerous backends.
I can do it the long winded way by connecting to each backend via
Set db = DBEngine.Workspaces(0).OpenDatabase(strdbName) etc ...
then looping through each applicable recordset and adding each record to a
local a temp table in the current backend.
I am pretty sure there must be a way to create the table using SQL INSERT
INTO for example SELECT tblemployee.* INTO tblemployees IN 'temp.mdb' but I
would ideally like to do it without having to relink to each backend.
Does anyone have any ideas or is there a better way to achive this?
many thanks.