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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by denaliak

  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.
See more

Part and Inventory Search

Back
Top