[AccessD] Checking if a file is open

Andy Lacey andy at minstersystems.co.uk
Mon Feb 9 10:52:43 CST 2004


You could try renaming it and bleep if you can't. Then rename it back if all
ok.
--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
To: accessd at databaseadvisors.com <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Checking if a file is open
Date: 09/02/04 20:27

>
> the easiest  (aaltough not the best) way would be to see what is the
> number of the error you are getting, and write code for that error
> prompting the user to close excel appl, and exiting the sub
>
> > Hi All,
> >
> > I am importing data from Excel into Access.  The initial step in this
> > process involves copying the data from the excel spreadsheet into a
> > temporary copy of itself.  This step fails if the file is open.  Does
> > anyone recommend a method that I could use to see if the file is
already
> >  open (and then notify the user to shut it down?)
> >
> > TIA
> > RyanS
> >
> >
> >
> > This e-mail and any attachment are confidential and contain
proprietary
> > information, some or all of which may be legally privileged.  It is
> > intended solely for the use of the individual or entity to which it
is
> > addressed.  If you are not the intended recipient, please notify the
> > author immediately by telephone or by replying to this e-mail, and
then
> > delete all copies of the e-mail on your system.  If you are not the
> > intended recipient, you must not use, disclose, distribute, copy,
print
> > or rely on this e-mail.
> >
> > Whilst we have taken reasonable precautions to ensure that this
e-mail
> > and any attachment has been checked for viruses, we cannot guarantee
> > that they are virus free and we cannot accept liability for any
damage
> > sustained as a result of software viruses.  We would advise that you
> > carry out your own virus checks, especially before opening an
> > attachment.
> >
> > The UK firm Ernst & Young LLP is a limited liability partnership
> > registered in England and Wales with registered number OC300001 and
is a
> > member practice of Ernst & Young Global.  A list of members?
names is
> > available for inspection at 1 More London Place, London, SE1 2AF, the
> > firm?s principal place of business and its registered office.
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
>
>
>
> -----------------------------------------
> Get Breaking News from CNN, ABC, NBC, CBS Now.
> http://www.xuppa.com/news/?link=webmail
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
>
>

________________________________________________
Message sent using UebiMiau 2.7.2



More information about the AccessD mailing list