friends

i have to shift my running inventory s/w (multuser system) from SQL server backend to ACCESS-2000. In sql server backend I have used @@IDENTITY to trace the last inserted ID to link order and orderDetails tables (FK).

if i convert the backend to ACCESS how i solve this problem. Mine is a multiuser system around 25 users are making order entries at a time.

pl. help

bobbytom