Can results of a Form be exported to a table on another database

R

Rob

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top