ACE provider for 64-bit Windows?
in [VbScript]
|
Prev: Processing e-mails as they arrive.
Next: What is best xmls2.xmlhttp xmls2.serverxmlhttp.6 or WinHttp.WinHtt
From: D.P. Roberts on 12 Jul 2010 11:30 I have a vbs file that uses the following line to connect to an Access 2007 (accdb) file: ..Provider = "Microsoft.ACE.OLEDB.12.0" This works fine as long as my OS is a 32-bit version of Windows XP/Vista/7, but it fails to run on 64-bit versions of Windows. Does anyone know how I can get a 64-bit version of Windows to work with this code? I asked this question in the office developer newsgroup but nobody could help. Thanks in advance for any assistance. D.P. Roberts
From: Evertjan. on 12 Jul 2010 11:58 D.P. Roberts wrote on 12 jul 2010 in microsoft.public.scripting.vbscript: > I have a vbs file that uses the following line to connect to an Access > 2007 (accdb) file: > > .Provider = "Microsoft.ACE.OLEDB.12.0" > > This works fine as long as my OS is a 32-bit version of Windows > XP/Vista/7, but it fails to run on 64-bit versions of Windows. Does > anyone know how I can get a 64-bit > version of Windows to work with this code? > > I asked this question in the office developer newsgroup but nobody > could help. Thanks in advance for any assistance. There seem to be different versions of this engine, downloadable here: <http://www.microsoft.com/downLoads/details.aspx?familyid=C06B8369-60DD- 4B64-A44B-84B371EDE16D&displaylang=en> [Warning: I did not try it out] -- Evertjan. The Netherlands. (Please change the x'es to dots in my emailaddress)
From: D.P. Roberts on 12 Jul 2010 12:42 Thanks Evertjan, but those are simply the 32- and 64-bit versions of the Access Database Engine. Correct me if I'm wrong, but I believe the 64-bit version of the Access Database Engine is only necessary if you're using Office 2010 which features a 64-bit version of MS Access. I am using Access 2007 which of course is 32-bit. My question was how to get a 64-bit operating system (like Windows 7 64-bit) running a 32-bit version of Access to work with the 32-bit Access Database Engine. "Evertjan." <exjxw.hannivoort(a)interxnl.net> wrote in message news:Xns9DB3B6E99EE34eejj99(a)194.109.133.242... > D.P. Roberts wrote on 12 jul 2010 in > microsoft.public.scripting.vbscript: > >> I have a vbs file that uses the following line to connect to an Access >> 2007 (accdb) file: >> >> .Provider = "Microsoft.ACE.OLEDB.12.0" >> >> This works fine as long as my OS is a 32-bit version of Windows >> XP/Vista/7, but it fails to run on 64-bit versions of Windows. Does >> anyone know how I can get a 64-bit >> version of Windows to work with this code? >> >> I asked this question in the office developer newsgroup but nobody >> could help. Thanks in advance for any assistance. > > There seem to be different versions of this engine, downloadable here: > > <http://www.microsoft.com/downLoads/details.aspx?familyid=C06B8369-60DD- > 4B64-A44B-84B371EDE16D&displaylang=en> > > [Warning: I did not try it out] > > -- > Evertjan. > The Netherlands. > (Please change the x'es to dots in my emailaddress)
From: Evertjan. on 12 Jul 2010 16:14
D.P. Roberts wrote on 12 jul 2010 in microsoft.public.scripting.vbscript: > "Evertjan." <exjxw.hannivoort(a)interxnl.net> wrote in message >> D.P. Roberts wrote on 12 jul 2010 in >> microsoft.public.scripting.vbscript: >> >>> I have a vbs file that uses the following line to connect to an >>> Access 2007 (accdb) file: >>> >>> .Provider = "Microsoft.ACE.OLEDB.12.0" >>> >>> This works fine as long as my OS is a 32-bit version of Windows >>> XP/Vista/7, but it fails to run on 64-bit versions of Windows. Does >>> anyone know how I can get a 64-bit >>> version of Windows to work with this code? >>> >>> I asked this question in the office developer newsgroup but nobody >>> could help. Thanks in advance for any assistance. >> >> There seem to be different versions of this engine, downloadable >> here: >> >> <http://www.microsoft.com/downLoads/details.aspx?familyid=C06B8369-60D >> D- 4B64-A44B-84B371EDE16D&displaylang=en> >> >> [Warning: I did not try it out] [please do not top post on usenet] > Thanks Evertjan, but those are simply the 32- and 64-bit versions of > the Access Database Engine. Correct me if I'm wrong, but I believe the > 64-bit version of the Access Database Engine is only necessary if > you're using Office 2010 which features a 64-bit version of MS Access. > I am using Access 2007 which of course is 32-bit. My question was how > to get a 64-bit operating system (like Windows 7 64-bit) running a > 32-bit version of Access to work with the 32-bit Access Database > Engine. That would be off topic. Access itself has nothing to do with classic ASP. So methinks you wanted a 64 bit ACE.OLEDB.12.0 for a W7-64bit ASP server? -- Evertjan. The Netherlands. (Please change the x'es to dots in my emailaddress) |