32 bit vs 64 bit

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

32 bit vs 64 bit

Post by Leesha »

Hi!!

I just upgraded my laptop. Office is in 64 bit. The db's I have built are in 32 bit. Whenever one of them opens o. A 64 bit machine it gives errors. Errors go away in 32 bit. Is there something that is needed in The reference library or so.e way to get past this?
Thanks
Leeaha

User avatar
HansV
Administrator
Posts: 78235
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: 32 bit vs 64 bit

Post by HansV »

If at all possible, I would recommend uninstalling 64-bit Office and replacing it with 32-bit Office.
The 64-bit version has few advantages but major incompatibilities. for example, ActiveX controls don't work in the 64-bit version.
If you have any VBA code that uses Windows API functions* you'll have to modify their declarations and often also the code that uses them.

* A Windows API function is defined by a line that starts with Public Declare or Private Declare, for example

Code: Select all

Private Declare Function WNetGetUserA Lib "mpr.dll" _
    (ByVal lpszLocalName As String, ByVal lpszUserName As String, lpcchBuffer As Long) As Long
For use in 64-bit Office, this would have to be edited.
Best wishes,
Hans

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Re: 32 bit vs 64 bit

Post by Leesha »

Thanks Hans!! I can Uninstall the 64 bit and will stick with 32 as you suggest.