[AccessD] Access 32 vs 64-bit

Bobby Heid bheid at sc.rr.com
Mon May 16 16:11:47 CDT 2011


I am using .Net (ASP.Net/VB.Net) to read Excel files.  The 2010 Access
runtime (which is what I thought we were talking about) has the OLEDB
drivers that I am using to do this and the runtime comes in comes both 32
and 64-bit versions.  That is what I was originally pointing out.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darrell Burns
Sent: Saturday, May 14, 2011 10:59 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 32 vs 64-bit

Sorry Bobby, but what do you mean you aren't using Access? Isn't that what
we're talking about? 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bobby Heid
Sent: Saturday, May 14, 2011 6:05 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 32 vs 64-bit

We are not using Access.  I was using the OLEDB drivers to access Excel.  

Did not mean to imply that the 32-bit version would not run On 2008 R2.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darrell Burns
Sent: Saturday, May 14, 2011 8:17 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 32 vs 64-bit

I have the same OS as you and was able to execute my 2007 runtime (based on
accde), but probably because I had installed the 32-bit version of Office
2010.

-DB

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bobby Heid
Sent: Saturday, May 14, 2011 1:03 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 32 vs 64-bit

FYI.  We are using the runtime at work on Windows 2008 R2 (64-bit only) and
had to switch to the 64-bit version of the runtime so that the website I was
working on can import Excel spreadsheets via OLEDB and .Net 4.0.  The 32-bit
version would not work on Windows Server 2008 R2.

Bobby


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darrell Burns
Sent: Thursday, May 12, 2011 7:01 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 32 vs 64-bit

Hmmm...so if the 32-bit runtime works in any environment, is there any
advantage to the 64 version? And would it run on a 32-bit machine?

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bobby Heid
Sent: Thursday, May 12, 2011 3:25 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 32 vs 64-bit

There is a 64-bit Access 2010 runtime:
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=57A350CD-5250-4D
F6-BFD1-6CED700A6715&displaylang=en

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
Sent: Thursday, May 12, 2011 2:42 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 32 vs 64-bit

For folks who may face this situation that originated this thread. I have an
Access 2002 runtime working on a Windows 7 64 machine in parallel with a
full install of Office 10. This the 32 bit version of Office not 64. As
others have said, stay away from Office 2010 64. 

So if you have an Access application to run on a machine with the 64 bit
version of Office I'd suggest using the runtime for whatever version of
Access the application was developed in.

Doug

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Wednesday, May 11, 2011 12:44 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access 32 vs 64-bit

But that isn't what was asked, what was asked is if you could Uninstall
Access x64 (leaving the rest of Office x64 in place), and then installing
just Access 32 bit. I don't think it will let that happen.

Of course, I'm not expert on this, I haven't tried doing it, but it's an
well educated guess that it won't work.

Installing the run time may or may not work, I am not sure.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
Sent: Wednesday, May 11, 2011 1:06 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 32 vs 64-bit

Drew,

I don't think that is correct. The runtime will install in the x86 programs
directory. This should work just like installing two different versions of
Access on the same machine. 

Doug
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Wednesday, May 11, 2011 10:44 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access 32 vs 64-bit

No, not on the same machine.  You could install 64 bit on the machine, and
then 32 bit in a virtual machine (like XP Mode for Windows 7), but the two
cannot co-exist on the same computer.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darrell Burns
Sent: Wednesday, May 11, 2011 12:23 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 32 vs 64-bit

Just to be clear on this, if I install Office 2010 64-bit I get Access
64-bit and if I install Office 2010 32-bit I get Access 32-bit, right?
Is it
possible to uninstall Access 64-bit and substitute Access 2010 32-bit?

--DB

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Wednesday, May 11, 2011 10:07 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access 32 vs 64-bit

Well Access 2010 x64 IS 64 bit, CODE WISE, so if you create a Long integer,
it is a 64 bit number.  They just didn't create a 64 bit Database inside
it... yet.  Because a 64 bit database would be unusable to a 32 bit version
of Access.  That wouldn't fly at all, it's one thing for the interface to
not work between 32 bit and 64 bit versions, but for the data to be unusable
between version would never fly.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darrell Burns
Sent: Wednesday, May 11, 2011 11:37 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 32 vs 64-bit

Thanx to all of you who jumped in on this thread. 

I don't know why my client installed Office 64-bit. Regardless of why,
that's what they've got and there ain't nothin I can do about it.

What I wasn't aware of is that Access 2010 is NOT 64-bit. 

Anyway, I found the reason why my runtime app won't work...because I
converted it to accde first. According to TechNet:

"Databases that have had their source code removed (such as .mde, .ade, and
.accde files) cannot be moved between 32-bit and 64-bit editions of Office
2010. Such databases that are created by using 32-bit Office (any
version)
can be used only with 32-bit Office, and a database that is created on
64-bit Office can be used only on 64-bit Office."

So, if A2010 is 32-bit does that mean even if I create an accde from
A2010
and package as a runtime it still won't run in Office 64?

--DB

 

 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Wednesday, May 11, 2011 8:36 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access 32 vs 64-bit

 

What did you install it on?  On a NICE system, it does perform better

than 32 bit Offices.  But the true 'performance' is the ability to go

beyond the 32 bit restrictions. But it looks like Access 2010 is stuck

with the 2007 Access db version, so it doesn't have a 64 bit database

version. (Imagine 64 bit integer fields, a 64 bit Currency field!!!)

 

Drew

 

-----Original Message-----

From: accessd-bounces at databaseadvisors.com

[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow

Sent: Wednesday, May 11, 2011 10:18 AM

To: 'Access Developers discussion and problem solving'

Subject: Re: [AccessD] Access 32 vs 64-bit

 

Problems. Little if any support for 3rd party add-ins, Active X

controls,

etc. 

 

I installed it once (MSDN) and it made no difference in performance so I

canned it.

 

-----Original Message-----

From: accessd-bounces at databaseadvisors.com

[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Erbach

Sent: Wednesday, May 11, 2011 9:52 AM

To: Access Developers discussion and problem solving

Subject: Re: [AccessD] Access 32 vs 64-bit

 

John,

 

>> Microsoft does everything they can to encourage people not to use it.

 

>> <<

 

Fascinating.  Why is that?

 

Steve Erbach

Neenah, WI

 

On Wed, May 11, 2011 at 9:35 AM, John Bartow <john at winhaven.net> wrote:

> Hi Darrell,

> I'd be interested in the reason they use 64 bit Office. Microsoft does

 

> everything they can to encourage people not to use it.

> 

> -----Original Message-----

> From: accessd-bounces at databaseadvisors.com

> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darrell

> Burns

> Sent: Wednesday, May 11, 2011 8:03 AM

> To: 'Access Developers discussion and problem solving'

> Subject: [AccessD] Access 32 vs 64-bit

> 

> Hello. I developed a 32-bit Access 2007 app with VBA code that uses

> DAO exclusively for data access and has no add-ins. My client has

> Windows 7 64-bit PCs running Office 2010 64-bit. I delivered the app

> as a 2007 runtime package and it didn't work at their place.

> The app runs fine on my WinServer2008 machine with Office 2010 32-bit,

 

> but I haven't tested it under Office 2010 64-bit.

> Since my other clients are still operating in the 32-bit world, I

> can't abandon the 32-bit version.

> Is there a way to satisfy both worlds with just one version?



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list