currently I use built-in function "Import from Access" with connection string (given automatically by excel)
Expand|Select|Wrap|Line Numbers
- Provider=Microsoft.ACE.OLEDB.12.0;
- User ID=Admin;
- Data Source=D:\data WS\WS admin.accdb;
- Mode=Share Deny Write;
- Extended Properties="";
- Jet OLEDB:System database="";
- Jet OLEDB:Registry Path="";
- Jet OLEDB:Engine Type=6;
- 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;
- Jet OLEDB:Support Complex Data=False;
- Jet OLEDB:Bypass UserInfo Validation=False
are there anyother method that let's me pull all data (refresh or whatever) without closing access :-?
edit: I found out I can change "Mode=Share Deny None" to fullfill my need.
sothat I want to ask 1 more question
if we use VBA code to pull data from Access, will it be faster than built-in connections ?