[AccessD] Access 32 vs 64-bit

Drew Wutka DWUTKA at Marlow.com
Wed May 11 12:07:01 CDT 2011


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

The information contained in this transmission is intended only for the
person or entity 

to which it is addressed and may contain II-VI Proprietary and/or II-VI
Business 

Sensitive material. If you are not the intended recipient, please
contact
the sender 

immediately and destroy the material in its entirety, whether electronic
or
hard copy. 

You are notified that any review, retransmission, copying, disclosure,
dissemination, 

or other use of, or taking of any action in reliance upon this
information
by persons 

or entities other than the intended recipient is prohibited.

 

 

-- 

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
The information contained in this transmission is intended only for the person or entity 
to which it is addressed and may contain II-VI Proprietary and/or II-VI Business 
Sensitive material. If you are not the intended recipient, please contact the sender 
immediately and destroy the material in its entirety, whether electronic or hard copy. 
You are notified that any review, retransmission, copying, disclosure, dissemination, 
or other use of, or taking of any action in reliance upon this information by persons 
or entities other than the intended recipient is prohibited.





More information about the AccessD mailing list