Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I close the connection from excel to access after refresh?
The following connection script was created by the excel wizard using:
Import external data ...edit query. How do I cloase the connection to the access databse after doing a refresh? Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin; Data Source=\\Iso-tst-00\testdev\db\test.mdb; Persist Security Info=False; Mode=Share Deny None; Extended Properties=""; Jet OLEDB:System database=""; Jet OLEDB:Registry Path=""; Jet OLEDB:Engine Type=5; Jet OLEDB:Database Locking Mode=0; Jet OLEDB:Global Partial Bulk Ops=2; Jet OLEDB:Global Bulk Transactions=1; Jet OLEDB:New Database Password=""; Jet OLEDB:Create System Database=False; Jet OLEDB:Encrypt Database=False; Jet OLEDB:Don't Copy Locale on Compact=False; Jet OLEDB:Compact Without Replica Repair=False; Jet OLEDB:SFP=False -- Steve S. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Excel and access update each other like a two way connection | Excel Discussion (Misc queries) | |||
VBA code to Refresh Connection for Excel Add-in for Analysis Servi | Excel Programming | |||
Excel/Access connection via ADO | Excel Programming | |||
Excel/Access connection via ADO | Excel Programming | |||
Excel does not close from VB!! (when i refresh Refresh query with BackgroundQuery:=False) | Excel Programming |