[AccessD] How to Discern if an Access Linked Table (Excel File) is Opened Exclusively by Another User

Sure.... use filesystemobject to try to rename it.
On Oct 10, 2012 5:57 PM, "Brad Marks" <BradM at blackforestltd.com> wrote:

> Is there a way using Access VBA code to know if an Excel file (defined
> to Access as a Linked table) is opened by another user?
>
> Thanks,
>
> Brad
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>