Ahtaf has attended:
Access Introduction course
Linking
Why would you link when you can export the table over ?
RE: Linking vs. importing table
Dear Ahtaf
Thank you for attending Access Introduction Course. I hope you enjoyed the course and are finding the topics covered during the training useful.
In Excel you link workbooks together so that when you make any changes in the source file the destination file updates automatically. The principal of linking tables is the same in Access.
If you import a table to a database and start adding more records it will only update the records in the table in the existing database. But what if you wanted the data to be updated in the original database as well?
If you create a link then the data gets updated in both the tables in both the databases. Unlike Excel in Access you can amend either the destination table or the source table. The linking works both ways. But in Excel you can only amend the source file to see the changes in Destination workbook.
I hope his has helped in answering your query.
Please mark this question as resolved if you feel that your question have been answered satisfactorily.
Many thanks
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007
