what I need to do is the following:-
1) Open a table to insert a new record
2) Lock this table so there is no new entries in it
3) get the maximum call number and add 1 to it
4) insert the new record
5) Unlock the table again.
How can i do it? I know how to insert the record and get the maximum call number. What i do not know is how to lock and unlock the table.
I am using ASP to do this. I tried several VBScript commands but they did not work since the connection is a ConnX connection to make Access talk with Dataflex.
Thanks for your help and time