External Data

[yooper_ssm]

Group

Thought:
I would like to retrieve data from a table in another database/s - on our
network - run it through a make table query to create a native table that has
NO LINKS to the outside database. The records could be event updated. The
user sees that the date - on a label that is on the form - is older than
he/she wants. They could click a button to recreate the records, or when I
open the main form if the records are older than a given time-span – like 6
hours - the data would then be automatically refreshed.

Regards
Mike Sundman

 

[yooper_ssm]

Group

Did some snooping around and this is what I came up with.

SELECT tblEmpCompleteData.strEmpNumber, tblEmpCompleteData!strEmpLastName &
", " & tblEmpCompleteData!strEmpFirstName AS FullName INTO
tblUnlinkedEmpIDAndFullName
FROM tblEmpCompleteData IN 'I:\Data Bases\DataFiles\Subdatabases Before
Merging\EmployeeData.mdb';