Friday, September 18, 2009

Supporting Different Versions of MS-Access's Using OLEDB Connection

Change:

// Create MDB file
obj.GetType().InvokeMember("Create", System.Reflection.BindingFlags.InvokeMethod, null, obj,
new object[]{"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + newDB + ";" });

to:
// Create MDB file
obj.GetType().InvokeMember("Create", System.Reflection.BindingFlags.InvokeMethod, null, obj,
new object[]{"Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Engine Type=4;Data Source=" + newDB + ";" });


http://support.microsoft.com/kb/230501/EN-US/ shows the different versions and their constant numbers.
sqldataaccess/thread

No comments:

Post a Comment

Followers