AutoNumber on Linked table

[rhughr]

Hello,

I have created a Linked table via ODBC. My ultimate goal is to create
a 'differential' report in Excel. By this I mean I want to display
data that has been added to the Linked table since the last 'run' (
someone will do a weekly check of this ). Unfortunetly, the
underlying table does not have any numerical row identifier. I believe
I can do most of the processing in Excel, via VBA and hidden sheets,
etc. But I would prefer to have Access to the work of spitting out the
incrementally added records.

I would like to create a persistent 'staging' table in Access which has
an AutoNumber column, which I can easily query into Excel. When I use
Query Builber in Access, it drops and re-creates the staging table each
time which means the row count always ends up as the total # of rows in
the Linked table.

Is there an easy way to do this? I guess I am looking for some sort of
VIEW that does not get recreated? Or a SQL Server-like Stored
Procedure that can build the Staging table off of the last record in
the Linked table?

Sorry if this is not all that clear, any help or feedback would be
apprecited.

Thanks.

 

[Roger Carlson]

You can use the DMax function to find the last saved number in a table. On
my website (www.rogersaccesslibrary.com), is a small Access database sample
called "AutonumberProblem.mdb" which illustrates how to do this.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L