This message is in MIME format. Since your mail reader does not understand

this format, some or all of this message may not be legible.



------_=_NextPart_001_01C1BA15.0A649CD0

Content-Type: text/plain



Hi Guys



I am trying to shut down access using the Application.Quit command in Access

VBA and shelling out to a bat file, however the bat file kicks in before

Access has had a chance to shut down properly. The bat fiel copies a later

version of the Access database just closed by overwriting existing one. But

because access isn't shutting down properly in the first place it can't copy

over it and leaves the database in an unrecognised format!!!



 



Is there a simple command either in DOS or may be in VB which waits until

access has shut down properly before invoking the copy command.



 



I'm really stuck with this any help would be highly appreciated.



 



Best regards



Omar







  DISCLAIMER: The information in this message is confidential and may be

legally privileged. It is intended solely for the addressee.  Access to this

message by anyone else is unauthorised.  If you are not the intended

recipient, any disclosure, copying, or distribution of the message, or any

action or omission taken by you in reliance on it, is prohibited and may be

unlawful.  Please immediately contact the sender if you have received this

message in error. Thank you.

This is a multi-part message in MIME format.



------_=_NextPart_001_01C1BA16.03F6662E

Content-Type: text/plain;

	charset="us-ascii"

Content-Transfer-Encoding: quoted-printable



In VB it could be done with Win API's by doing a window or a process

search and waiting until the search comes back negative.  In DOS I know

of no way to do so offhand.



-----Original Message-----

From: Omar Chaudry [mailto:OChaudry@b...]

Sent: Wednesday, February 20, 2002 8:47 AM

To: Access

Subject: [access] Quitting Access Remotely



Hi Guys

I am trying to shut down access using the Application.Quit command in

Access VBA and shelling out to a bat file, however the bat file kicks in

before Access has had a chance to shut down properly. The bat fiel

copies a later version of the Access database just closed by overwriting

existing one. But because access isn't shutting down properly in the

first place it can't copy over it and leaves the database in an

unrecognised format!!!



Is there a simple command either in DOS or may be in VB which waits

until access has shut down properly before invoking the copy command.



I'm really stuck with this any help would be highly appreciated.



Best regards

Omar








DISCLAIMER: The information in this message is confidential and may be

legally privileged. It is intended solely for the addressee. Access to

this message by anyone else is unauthorised. If you are not the intended

recipient, any disclosure, copying, or distribution of the message, or

any action or omission taken by you in reliance on it, is prohibited and

may be unlawful. Please immediately contact the sender if you have

received this message in error. Thank you.