|2000 or 2003||
|2007||To import tables:
To link tables:
|Imported Tables||Linked Tables|
|Data is local — the entire contents of an imported table are read into a copy on local storage.||Data is remote — only rows requested from the linked table are read into local storage.
Note: You can link to a local table, rather than creating a second copy by importing it.
|Importing can take several seconds, or even minutes, depending on the size of the database.||Creating a link is almost instantaneous, depending on the network connection.|
|Space is required for local copies of imported tables.||The link requires very little local storage.|
|Data is static — if there are changes to the database, they are not reflected in local data. If the database is subject to frequent changes, linking can be preferable.||Data is dynamic — you have access to any changes.|
|If the network connection is broken, users still have access to data.||If the network connection is broken, users have no access to data until connection is restored.|
|Users cannot write to the indexed file source.||Users can write to the indexed file source if the data source name (DSN) is read/write and the user has INSERT and/or UPDATE permissions on the object|
As a guideline, re-linking or re-importing is required when the table structure — such as the number of columns, or their names, sizes, and types — changes.
The AcuXDBC Login dialog box appears if you or an administrator established database security methods during AcuXDBC setup. If no security methods were established, a User ID and Password are not required, and the Login dialog box will not appear.