User-defined functions
Date: Sun, 23 Jan 2005 09:33:05 -0800
I'm a very new learner in SQL Server 2000 now - Can I link to user-defined
functions for an Access front-end .mdb just as with SQL Server Views? I know
that functions are used with Access projects, but I need parameterized
functions for an .mdb which does not lend itself to be converted to a
project.
Thanks.
Relevant Pages
- Access should not expose SQL UserID / Passwords
... Server with an Access application (Access front-end) (SQL Server back-end) ... readable in the MDB and possibly in the MDE. ...
(microsoft.public.access.security) - Re: User-defined functions
... You should be able to use your function in a sql view and then link to the ... > functions for an Access front-end .mdb just as with SQL Server Views? ... > that functions are used with Access projects, ...
(microsoft.public.sqlserver.programming) - 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) |
|
