Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. denaliak

    Getting RETURN VALUE with Pass Thru Query

    Thanks. This is a good idea when running the query directly from the Access code but I need to know if rowback occured within a SQL stored procedure when several queries are run. Looking for a way of checking the @@error and returning that value with the RETURN @@error statement.
  2. denaliak

    Return Value Passed to MS Access

    I have a program that I inherited that uses pass thru queries to update a SQL table. Sometimes the query will fail but this is never reported back to Access. How can I use the RETURN Value of SQL to send a value back to MS Access? What is the Access code to receive this value? It is written...
  3. denaliak

    Getting RETURN VALUE with Pass Thru Query

    I have a program that I inherited that uses pass thru queries to update a SQL table. Sometimes the query will fail but this is never reported back to Access. How can I use the RETURN Value of SQL to send a value back to MS Access? What is the Access code to receive this value? It is written...
  4. denaliak

    Copy SQL database and clear data tables

    I need to make a copy of a database and delete all of the records from the user defined tables. I want to keep only the table definitions and stored procedures. What is the best way to do this. I am quite new to SQL. We are using SQL 7. Thanks
  5. denaliak

    Converting Access front-end and SQL back-end to asp pages

    What is the quickest way to convert Access 2000 forms and code to asp pages. They would use the same SQL back-end.

Part and Inventory Search

Back
Top