How to link a table from front end to back end in split database (MS Access 2010) -
i have created split database in ms access 2010, in front end database have added table , want link end database. how can resolve issue?
in end database, go external data > access (import , link group):
in external data window, browse front end database file , open it:
when come external data window, select "link data source..." , click ok:
a link tables window appear, list tables available front end database linked to. select table(s) want link , click ok:
the table(s) selected front end database should show in navigation left:
...note difference in icons in above screenshot (linked tables little blue arrow; local ones not).
Comments
Post a Comment