ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how do I close the connection from excel to access after refresh? (https://www.excelbanter.com/excel-programming/399070-how-do-i-close-connection-excel-access-after-refresh.html)

Steve[_92_]

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.


All times are GMT +1. The time now is 01:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com