Hi :

I am using MS sql server 2005 and build the linked tables in access to link to the tables in server side.

I could open the linked table and update the table. However, when i run my VB code to update the linked table( say a), the updating could finish and the connection to the access is disconnected in code, if i want to reopen the linked table(a) in access, it gives an timeout error.  if i try to open the table a in server, the table could not list all the rows in it. It seems the table is locked. could anyone tell me how to solve it? thanks a lot!