Run code AFTER Access closes (1 Viewer)

theDBguy

I’m here to help

Staff member

Local time

Today, 09:41

Joined

Oct 29, 2018

Messages

21,467

• Mar 28, 2019

• #21

CedarTree said:

I guess somehow the batch file knows how to wait for Access to close... I'll give it a try.

Click to expand...

Either that or the batch file is too slow to start, which allows Access to quit before any problem happens. Let us know how it goes...

 

C

CedarTree

Registered User.

Local time

Today, 12:41

Joined

Mar 2, 2018

Messages

404

• Mar 28, 2019

• #22

Works like a charm.

 

theDBguy

I’m here to help

Staff member

Local time

Today, 09:41

Joined

Oct 29, 2018

Messages

21,467

• Mar 28, 2019

• #23

CedarTree said:

Works like a charm.

Click to expand...

Congratulations! Glad to hear you got it to work. Thanks to Bob! Good luck with your project.

 

C

CedarTree

Registered User.

Local time

Today, 12:41

Joined

Mar 2, 2018

Messages

404

• Mar 28, 2019

• #24

It must be the ping line - it waits 2000 milliseconds. I think June7's code would do the same thing but I wasn't following that code as easily as Larson's. Thanks everyone for the input.

https://www.computerhope.com/pinghlp.htm

 

Gasman

Enthusiastic Amateur

Local time

Today, 17:41

Joined

Sep 21, 2011

Messages

14,258

• Mar 28, 2019

• #25

theDBguy said:

Either that or the batch file is too slow to start, which allows Access to quit before any problem happens. Let us know how it goes...

Click to expand...

He uses the ping command to put in a delay.

 

C

CedarTree

Registered User.

Local time

Today, 12:41

Joined

Mar 2, 2018

Messages

404

• Mar 28, 2019

• #26

I think you could also use this: timeout /t 2 >nul