ID Number: Q69990
1.10 1.11 4.20
OS/2
Summary:
Once a user has logged onto SQL Server with Q+E, the File Open command
(from the File menu, choose Open) is used to access database tables.
After issuing the command, a dialog box appears that contains both a
Table List and an Owner List. The Owner List contains SQL Server
database names enclosed in square brackets ([pubs]). It also contains
user names for the selected database. The Table List contains a list
of tables that the selected username owns.
If you log onto SQL Server with Q+E using a specific username and
choose the File Open command, the Table List only displays objects the
username has created and owns. Objects the username has permission to
access are not displayed in the Table List. To access these objects
from the Table List, you must first select the DBO (database owner)
username in the Owner List. Because the DBO is the owner of all
objects in the database, the desired tables will then be included in
the Table List. At this point, you can select and open the tables.
It is important to note that while selecting DBO allows you to open
your tables from the Table List, there also may be tables listed that
you do not have permission to access. If these tables are selected,
Q+E will give you a warning, and the table will not be opened.
For more information on how Q+E handles SQL Server permissions, see
Appendix D, "Using Q+E with SQL Server," in the "Q+E for Microsoft
Excel User's Guide."
Additional reference words: 1.10 1.11 4.20 QPlusE Excel user name