multi user method in access

[bobbytom]

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

[bobbytom]

no one to ans. my queries

[catalintcg]

Try to store in tables all the informations about the users. It is difficult and takes a lot of time but I think this is the best solution in Access.

Regards.

[M Owen]

Question: Why in the world would you want to move FROM SQL Server BACK to Access? Isn't that migrating the wrong way? Why go from a database that is robust, scalable, and MULTI-USER bulletproof to one that you're only asking for BIG time headaches with 25 users hitting it at the same time?