Tables Views Functions

From: ann (ann_at_discussions.microsoft.com)
Date: 01/24/05

Next message: Hans Nelsen: "Re: Can't query linked Access database specified by UNC"
Previous message: Riki: "Re: Who deleted my records?"
Next in thread: Sue Hoegemeier: "Re: Tables Views Functions"
Reply: Sue Hoegemeier: "Re: Tables Views Functions"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: Mon, 24 Jan 2005 10:13:01 -0800

Can I create pass-through queries in an Access frontend
.mdb - then NOT give my users permissions to view the underlying tables in
SQL Server. Our goal is to allow paramertized queries with limited output,
but not allow any SQL Server users to link to the huge SQL Server tables via
ODBC.

OR - Are "user-defined functions" the same as Views - so we could link to
those from an .mdb instead of to whole table views.

We do need to pass in paramters. AND - the Access .mdb cannot be converted
to a project.

Thanks for any help and your experiences.

Next message: Hans Nelsen: "Re: Can't query linked Access database specified by UNC"
Previous message: Riki: "Re: Who deleted my records?"
Next in thread: Sue Hoegemeier: "Re: Tables Views Functions"
Reply: Sue Hoegemeier: "Re: Tables Views Functions"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Relevant Pages

Re: From .mdb to .adp database
... I decided to go on with adp project, and i have created a store ... But queries are different stories. ... In SQL Server, there are Views, Stored Procedures, UDFs. ... Also, when you decide to use MDB front-end, you can choose use MDB ...
(microsoft.public.access.adp.sqlserver)
Re: From .mdb to .adp database
... there is no exact equivalent query object in SQL Server to MDB's query. ... Most likely, the wizard converts MDB queries to Viwes or SP, if the queries are convertiable. ... Also, when you decide to use MDB front-end, you can choose use MDB queries in the front end or use SQL Server side query objects. ... SQL Server is very powerful server software, whether you use MDB, ADP or anything else to access data from it, you MUST learn how to use it and almost for sure you need to learn another programming environment. ...
(microsoft.public.access.adp.sqlserver)
Re: From .mdb to .adp database
... there is no exact equivalent query object in SQL Server to MDB's query. ... Most likely, the wizard converts MDB queries to Viwes or SP, if the queries are convertiable. ... Also, when you decide to use MDB front-end, you can choose use MDB queries in the front end or use SQL Server side query objects. ... SQL Server is very powerful server software, whether you use MDB, ADP or anything else to access data from it, you MUST learn how to use it and almost for sure you need to learn another programming environment. ...
(microsoft.public.access.adp.sqlserver)
Re: Upsizing design considerations
... reports, with a ADP, or mdb (actually, it should be mde, or a ADE when you ... you would LINK the tables to sql server, and NOT USE a adp (the reasons is ... the first two remote users ...
(microsoft.public.access.gettingstarted)
Re: Front End options
... SQL Server if you follow my recommendations in. ... you could easily support hundreds of concurrent users. ... Does a mdb FE work well regardless of how many tables ... >>subforms well. ...
(microsoft.public.sqlserver.clients)