home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Programming Tool Box
/
SIMS_2.iso
/
access
/
diverses
/
params
/
params.txt
< prev
Wrap
Text File
|
1995-01-11
|
3KB
|
79 lines
Parameter Typing Utility
This utility will help automate the process of explicitly
defining the data types of parameters. It will loop through
all of the queries in a database and for all parameters
which are not explicitly typed, prompt for the type.
How to Install:
---------------
This utility is a single form which can be installed as an Add-In or the form, Parameter Typing Utility, can be imported into any database.
To install as an Add-In:
1. Open any database in Access.
2. From the File menu choose Add-ins and then select Add-in
Manager.
3. Choose Add New.
4. Locate PARAMS.MDA and choose OK.
5. Restart Access.
To run the Add-in, choose Add-ins from the File menu and
then select Start Parameter Typing Utility.
Press the Start button to start looping through the queries.
Press the List Parameters button to create a list of all
parameters and queries.
To import the form:
All of the code is behind the Parameter Typing Utility form.
This form can be imported into any database. To start the
utility, open the form.
Press the Start button to start looping through the queries.
Press the List Parameters button to create a list of all
parameters and queries.
Updating Append and Update queries only:
----------------------------------------
There is a check box, which is checked by default, to indicate
whether only Append and Update queries should be checked or if
all queries should be checked.
How it works:
-------------
The code loops through each query. For each parameter that is
not already explicitly typed, the form will prompt for the data
type. If you are unsure of the data type, you can either
skip the parameter or you can switch away from the form and
check the table. You also have the option of skipping a
query or quitting.
The List Parameters button will create a table with the
Query Name, Parameter Name, and a Yes/No field indicating
whether the parameter is explicitly typed.
Why do this?
------------
Using Jet 2.5, append and update queries that rely on
parameters may fail with type mismatch errors. The data
types of the parameters need to be explicitly typed in order
for the queries to execute successfully. This utility helps
automate the process of explicitly typing the parameters.
Note: There is a Knowledge Base Article in process that
describes this issue in more detail.
Disclaimer:
-----------
This utility is provided "as is" without warranty of any kind,
either expressed or implied, including without limitation the
implied warranties of merchantability and fitness for a
particular purpose.
The user assumes the entire risk as to the accuracy and use of
the document. In no event shall Microsoft or its suppliers be
liable for any damages whatsoever, including without limitation,
direct, consequential, indirect, incidental, loss of profit or
special damages, even if Microsoft has been advised of such
damages. Because some states do not allow the limitation of
consequential or incidental damages, the foregoing limitation
damages may not apply to you.