How to simple retrieve autonumber valuees or identity from data source

  • Thread starter Thread starter £ukasz Margielewski
  • Start date Start date
£

£ukasz Margielewski

I use the access database in my simple application. That database doesn't
support stored procedures. In the one of te Microsoft tutorilas,they propose
to solve this problem by attend the row update event. Is any simplest
solution?
 
First off, you can write the equivalent of a stored procedure in Access. They
are called queries. Simply write your SQL in a query and save it. Call it by
name. You will have to set the command object to CommandType.StoredProcedure
and attach any parameters by name. I am, by no means, an access expert,
however, so I am not sure if you can chain commands in a single query to get
the latest value out. If not, Row_Update may be the best option.

In most cases, I would prefer using MSDE to Access. If that is an option,
the app can later be upgraded to SQL Server without much, if any, pain.

---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
 
Back
Top