Return last record inserted into table

[MajP]

I have a replicated database where the primary key is an autonumber and random. I have limited access to the backend structure (i.e. adding fields).

So is there a way to determine the last record inserted into a table without an increasing autonumber or date time stamp? Thanks. Thanks in advance.

 

[SkipVought]

Hi,

A table is like a bag of marbles. Which marble was the last one dropped into the bag? Unless you have a way to tag each marble, like date stamp or highest autonumber.....

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[MajP]

I am learning that even if you think you will not need it, to put a time stamp in all data tables. The issue was that the original table had an increasing autonmumber but when replicated it becomes random. I will have to get my hands on the design master and enter a time stamp. Thanks.

 

[RoyVidar]

Depends how you're inserting them, and at which point of time you need the number.

If you use SQL, you can retrieve the last autonumber (identity) on the same connection through SELECT @@IDENTITY, see

http://support.microsoft.com/kb/232144

for more details

Roy-Vidar

 

[PWise]

FYI

you can retrieved from access by opening a recordset

 

[FabricMan]

I don't know enough about your structure, but you might try timestamping users who enter records.

 

[jmstarbuck]

How can you retrieve the next autonumber by opening a recordset in Access?

I've tried determining the max value of the autonumber field and adding one, but that doesn't work once I delete some rows.

J