William Benson
vbacreations at gmail.com
Wed Oct 10 17:11:59 CDT 2012
You will need to break the link to rhe table and relink it in order to do this. On Oct 10, 2012 6:03 PM, "William Benson" <vbacreations at gmail.com> wrote: > 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 >> >