When you want to open more than one instance of a table, then you can select the table and click on Open Copy.
If you are familiar with SQL then perhaps you want to use a SELECT command against your connection. Use the Open Command command from the Table menu to enter any SQL command. If it yields a recordset (like a SELECT command) it gives you a table like the Open command does. But you can also enter any other valid SQL command. In professional mode you may use the SQL Cook.
To rename a table, just click on its node at the Connections window and wait a second, then click again. If the node isn't a database table but a command or a table copy this doesn't rename a table; it only changes the caption of the table's form. Similarly you can rename a connection node. If you are using a .conn file, this caption may be saved for future sessions.
You can rename table nodes and connection nodes only, not the other nodes.
With the bAsk ADO
Viewer you can get information about connections and about the recordset of open tables.
Use the Properties command from the File menu to see info about the connection
or use the Properties command from the Table menu to look at the details of a
table.
The Tips window is displayed at the bottom of the main window, just above the
status bar. You may use View → Tips or ? → Next Tip to display the Tips window.
When you've enjoyed the tip, you may press the Close button
at the right
of the Tips window or even the Next Tip button
. You may resize the
Tips window by dragging its upper edge.
If you're switching off the Tips window through View → Tips, you're asked whether the display of the Tips window on startup should be suppressed, too.