Hi All,

I am using Access as a quickie front-end to our Oracle databases.

One of our procedures writes the Oracle RowID to a custom column
called ROW_NUMBER.

I'd like to use that number in my WHERE clause for a table, but since
Access doesn't see "RowID" anywhere, Access's SQL treats it as a
parameter and asks me to enter "rowid" in as I execute the SQL.

Anyone know if it's possible to use the Oracle RowID from within
Access?

Thanks,

Jon

If you create a view, and then link to that view, then any query you build
in access based on that linked view can use the row_number...


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal (AT) msn (DOT) com

On Jul 27, 5:51*pm, "Albert D. Kallal" <PleaseNOOOsPAMmkal... (AT) msn (DOT) com>
wrote:
Gotcha. Thanks, Albert. It kills my "quick and dirty" effor to build
a View, but it's nice to know the method's there the next time someone
tells me I "can't" do it.

Jon