i havw excel a vba macro that reads records in an access database table on a network drive. I only have read only access to the network, however if my excel vba macro is reading the access table, and the owner of that access table is trying to read or write to his tables, he is locked out because i'm accessing it. So, even though i only have read only access to his tables, i still lock him out. is there a way i around this so that i can read his tables at anytime without locking him out? i tried reading the records from an access query instead of directly from his tables, but this did not help.
im looking for a vba solution. thanks.