Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Supplied provider is different from the one already in use
I get this cryptic message when attempting to open an ADO connection
using VBA with Excel 2010, SS2008R2, and Win7 Enterprise 64bit. Didn't happen with Excel 2003, SS2005, WinXPPro. Any thoughts on why this happens and how to fix it? Thanks! Kevin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Supplied provider is different from the one already in use
kevinlcarlson was thinking very hard :
I get this cryptic message when attempting to open an ADO connection using VBA with Excel 2010, SS2008R2, and Win7 Enterprise 64bit. Didn't happen with Excel 2003, SS2005, WinXPPro. Any thoughts on why this happens and how to fix it? Thanks! Kevin Have you updated your code to use the ACE provider that Excel 2007/2010 uses? Your 2003 code would have used the JET provider, and so needs to be revised to be version aware if you want it to work in both environments. If Application.Version = 12 Then 'use ACE provider connection string Else 'use JET provider connection string End If </aircode -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Are there any free macros for statistics supplied with excel? | New Users to Excel | |||
exact value from supplied Row and Column data | Excel Worksheet Functions | |||
What Is The Right Provider? | Excel Programming | |||
How do I make a file read only unless a password is supplied? | Excel Discussion (Misc queries) | |||
VBA retrieving row and column info from user supplied range(s) | Excel Programming |