I have Access 2007 and am in Windows Vista and need help on the
following:
Is it possible for the results from a Form in one database be exported
to a table in a second database located on a network.
Form1 is in database DB1 located on my hard drive (C:\Data), and I
want the results of what I entered into Form1 be exported to Table1 in
database DB2 located on T:\Data.
And then have a report, Report1 on my DB1 (located on C:\Data)
retrieve data from Table1 off DB2 (located on the network T:\Data).
Is this feasible? If so can anyone help me understand the code I need
to write to make this work.
TIA
Rob
|
