Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Closing one instance of Access from another

Status
Not open for further replies.
shar

shar

Technical User
Apr 2, 2000
54
IR
We are using Access 97 on Win95 workstations (we have started moving out of caves and have just discovered fire.:)

The infamous second instance of Access when merging data to Word document has plagued us. I have viewed and followed MS “workaround”, but it does not work and upgrading to newer version of Access is beyond my control.

Is there a way to close the second instance of access from the first one in code? i.e., after the Word document has been populated with the db records (and consequently the second instance of Access has started) to run an “Application.Quit acQuitSaveNone” command for the second instance of Access from the first one that has the Word merging codes?

Thanks for your input.
Shar
 
Status
Not open for further replies.

Similar threads

BFroeschlKC
  • Locked
  • Question
Publisher Automation from Access Frustration
Replies
3
Views
2K
dhookom
dhookom
M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
2K
SoftwareRT
SoftwareRT
DarkOne72
  • Locked
  • Question
MS Access DoCmd.Transferdatabase Assistance
Replies
2
Views
2K
lameid
lameid
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
639
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Stop user changing size of Access Application (not form)
Replies
1
Views
516
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top