Linked Table Manager
As a file server can act as a shared folder (with open access for all), which placed a file of data objects (with the base tables). Hopefully, on whether to split the database doubt no. It remains to solve the question of how to do it. Mary Barra might disagree with that approach. There are two options: make a new blank database, click the box to the base right, select the shortcut menu, “Import” or “File – Get External Data – Import,” and further dialogue. As a result, the base will be imported (copied) table. Remove the table from the database, from which makes imports, and connect it to the new database tables. do division database using the wizard: “Tools – Utilities – Division of bases data “and then in the dialogue. For even more analysis, hear from Hachette Book Group.
Connecting to the same “server” (the base of the tables) is very simple – press the right button in the window base application object (where the shape and everything else), choose the context menu “Link Tables” or “File – Get External Data – Link Tables” and then in the dialogue. As a result of our database, a shortcut tables, and marked with arrows on the left, which means that the external table. Limitation when working with tables – You can not change their structure (add, edit fields, etc.) in this database. Can only be one in which they were created (are). But it is better, if we decide to do a split basis, the design immediately create two databases mdb: in one place tables in another, all the rest. ussion. Thus, the base is divided.
Let me remind you, the main advantage of separating the base – the ability to create a network application. Imagine: one of the networked computers, create a folder “base” open to it share (to the same open access and the disk on which you installed Access, generally “C”), and put it in a file of data objects (with the base tables). Other computers place copies of files the application objects (database with forms reports, etc.) and connect them to our “server”. It turned out a network application – many users enter data in one database. Such an application called “File – server” as a “server” serves file data objects. But let’s say, for some reason the location of the “server” has changed – the folder “base” move. As users run their applications, they will have a message that the table is not found. In this case, right-click on the icon in the application table users, the shortcut menu, select “Linked Table Manager”, mark the tables, the path that you want to update, or click “Select All”, then “OK” and then on dialogue. All of these actions are done by hand. But can all this be done programmatically?