I need to add to a linked table. the user has added a record to query that intends to insert into a linked table with numerous relations. In order to do so I need to determine whether the user is online, such that the linked table has the most up to date product numbers.

How do I determine if the linked table is connected to the database so that I can get the latest product number and add 1 to it for the add query.