1. I have upsized a whole company database to SQL server7.0 However, the front end for the user will remain Access.The user supplies variables through forms. The problem: how can I call a query in SQL that uses the variable entered by the user?? Sometimes the user will only supply varible through option bottom. In other words, how can I pass variables in Access as parameters using SQL pass-through queries?

2) How can I write a user defined function and apply that function to a column in a certain table in SQL server?

3) Is there any performance degradation in using Views in T-SQL queries instead the base tables. 4. The same SQL Server application slows down almost to a halt whenever about 10 users login concurrently. How can I improve the performance. Thanks for your help.

-- Anonymous, February 29, 2000

Answers

Austin,

1. Use the Access Eval function to embed the option button variable in the string that is sent as the pass-through query.

2. Transact SQL does not currently support user defined functions. This will be supported in SQL Server 2000. In the meantime, you can use pass-through query statements like:

Update TABLE1 set ValueColumn = ValueColumn + 1

3. You should see no difference.

4. Examine and optimize the SQL Server queries. In particular, make sure you are using appropriate indexes and limiting the number of rows being returned.

Hope this helps,

Eric

-- Anonymous, February 29, 2000