[RESOLVED] Primary Key Auto-increment

[si_the_geek]

Just to clear a doubt: Can't an applic created with ms access be deployed for a multi-user access? I guess it can right?

It can indeed.. but you don't want to be using Access if you are expecting lots of users (generally if you have more than 5 users, you should use a different database system).

I assume the program proceeds by opening a table exclusively when a user adds in a new record. hence @@identity should work correctly isnt it?

Not really.. the program should not open the table exclusively, it should only block other users from editing exactly the same record (and only if you have specified that).

I don't know the details of how @@identity works in Access, but I presume there is a separate copy for each user, rather than one copy for the whole database.