update imported table like a refresh

[cmul]

I have an access database as a backend to store my data. We use a visual basic front end. I would like to use the data in the backend in another smaller access database. I know i can link the tables from one to another. But if i do this i can't add anything in the other smaller database as they are only linked. If i import the table to another smaller database i can add more data and fields however i can't update the data from the original database (backend) to the imported table. Is there a way that i can update the data from the backend database to the imported table, like a refresh would do if you have an excel query running i guess.

[NTC]

A linked Access table is between the Front End and the Back End. An FE can link to tables in differing separate database BEs - and have complete updateability.

One does not / can not: "link from one table to another".

Hope this clarifies your options.