Dear all,
as in my question title I am re-writing code of excel vba 2007 project to work with excel 2003, so instead of using connections in 2007 I will use queryTable in 2003, so my problem is if the connection string in 2007 is
strcnnString = "OLEDB;Provider=Microsoft.ACE.OLEDB.12.0;Password="""";User ID=Admin;Data Source=" & Me.DBFolderName & ";Mode=Share Deny Write;Extended Properties="""";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Database Password="""";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;Jet OLEDB:Support Complex Data=False"
so what is should be in excel 2003?
I wish to have connection string which works in ver. 2003 with the same details and abilities of the above one.
I got this error
Run-time error '1004': Initialization of the data source failed. check the database server or contact your database admin.........
in this line of code
ActiveSheet.QueryTables(me.cnnName).Refresh
thanks in advance