Where do views, etc. live?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Allen_N - 06 Nov 2006 21:58 GMT

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?

Reply to this Message

Van T. Dinh - 07 Nov 2006 11:34 GMT

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 ...

Signature

HTH
Van T. Dinh
MVP (Access)

>I am converting an MDB (which had links to existing tables) to an ADP. I
>did
[quoted text clipped - 14 lines]
> 3rd-party
> application?

Reply to this Message