Where do views, etc. live?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am converting an MDB (which had links to existing tables) to an ADP. I did
not upsize -- I just created the ADP.

I am concerned about leaving too many footprints in the back-end of a major
(3rd-party) application, as all I want to do is run SELECT queries.

My question is: will the views and tables I create normally be visible to
others who have access to the existing tables, or are they restricted to my
user profile (so that they only show up in my Access database/project
window)?

Also, if tables & views I create are visible to all, can I locate them on
another part of the server so that they don't look like part of the 3rd-party
application?
 
Tables and Views in ADP actually reside on the SQL Server. Access to these
depends on the permissions set on the SQL Server. For example, "sa" will,
of course, be able to see oyur Tables & Views. Any logins with the dbowner,
Data Reader/Writer permission will also be able to see as well, AFAIK.

Suggest you check with your SQL Server Admin on how to proceed ...
 
Back
Top