access数据库拆分的用途_将Access数据库拆分为前端和后端

Okay so I split my access database, and now I have a backend:

If I started a brand new table, a brand new query, and a brand form for a different purpose within the db_be.mdb would it appear in the connect "front end" db as I saved it in the backend, or do I have to import it up?

If I do have to import the above, the how do I make the table to stay in the back and just linked to the front end...with "link table"?

at this point if I create an MDE, will there still be a total of three (back end, what is now the front end, and eventually an MDE)??

thanks guys

解决方案

Normally, the whole point of a FE/BE database is to have only tables in the BE and everything else in the FE. You would create the table in the BE, then open your FE and link the table. You can use the Link manager (Tools/Database Utilities/Linked Table Manager) or directly (File/Get External Data/Link Tables) Then you would build your forms/queries in the FE.

When you create an MDE it will be a third, separate file, as you mention.