how do I close the connection from excel to access after refresh?

S

Steve

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

USING FIELD DATA FROM USERFORM 0
Can't change connection property on querytable 4
4 out of 35 data connections running high cpu/memory 0
Need consistent path name for Excel-->Access query; Excel keepschanging it 1
Hyperlinks not sticking when auto importing data from another work 0
Importing Data from Access Query to Excel Sheet 4
Input Box Help 0
Ignore table formatting when importing data using OLEDB 0

Top