Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

don't understand initialization Information

Status
Not open for further replies.

alh1002

Technical User
Mar 27, 2006
41
US
I copied a table, just using copy paste, and renamed the old table
tblPerformance_old
and renamed the new one I copied just tblPerformance.

I did this as I am testing some new data used for calculations.

Anyway, when i run the vba code in excel which calls the table, I get an error box

"Please Enter MS JET OLE DB Initialization Information"
it gives me the path,
username
password
provider string
open Mode: DB_MOD_READWRITE

if I push ok it works, but why is is popping up? I can't give this to others if it popping up errors.

here is the code in excel
With ActiveSheet.QueryTables.Add(Connection:=Array( _
"OLEDB;Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=C:\Documents and Settings\ahenderson\My Documents\june2.mdb;Mode=Share Deny Write;Ext" _
, _
"ended 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 Data" _
, _
"base 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"), _
Destination:=Range("B36"))


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top