Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


Rickles

2736 posts

Uber Geek

Trusted

#311215 23-Dec-2023 20:22
Send private message quote this post

A group I assist with has a membership database that was created in 2016 and uses Access and VBA coding.

 

However, it only seems to work when using 32-bit version of Office/Access.

 

Any ideas why it cannot be run on a 64-bit version?

 

The only thing I can think of is that it still uses CDO for sending emails, but I cannot find any information to suggest that this could be a hindrance.

 

Would/should it run on 64-bit using Compatibility Mode? 

 

 


Create new topic
elpenguino
2969 posts

Uber Geek


  #3175094 23-Dec-2023 23:52
Send private message quote this post

When you say it "doesn't run" , what does that mean?

 

Can you open a form , a table, run a query etc etc.

 

At work we run a much older Access DB than that and it runs on O365 just fine.

 

 





Most of the posters in this thread are just like chimpanzees on MDMA, full of feelings of bonhomie, joy, and optimism. Fred99 8/4/21


 
 
 

Trade NZ and US shares and funds with Sharesies (affiliate link).
mentalinc
2853 posts

Uber Geek

Trusted

  #3175116 24-Dec-2023 06:07
Send private message quote this post

is it hard coded to C:\Program Files (x86)? but 64 bit office should be in C:\Program Files

 

 





CPU: AMD 5900x | RAM: GSKILL Trident Z Neo RGB F4-3600C16D-32GTZNC-32-GB | MB:  Asus X570-E | GFX: EVGA FTW3 Ultra RTX 3080Ti| Monitor: LG 27GL850-B 2560x1440

 

Quic: https://account.quic.nz/refer/473833 R473833EQKIBX 


MickeyD
95 posts

Master Geek

Lifetime subscriber

  #3175138 24-Dec-2023 09:06
Send private message quote this post

Are you getting any error messages?

 

In my experience this usually needs the PtrSafe keyword added to declare statements when calling external libraries, e.g.

 

Private Declare PtrSafe Function apiGetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long
    
Private Declare PtrSafe Function apiGetComputerName Lib "kernel32" Alias "GetComputerNameA" (ByVal lpBuffer As String, nSize As Long) As Long
    
Private Declare PtrSafe Sub sapiSleep Lib "kernel32" Alias "Sleep" (ByVal dwMilliseconds As Long)

 

Reference: ptrsafe-keyword




Rickles

2736 posts

Uber Geek

Trusted

  #3175141 24-Dec-2023 09:19
Send private message quote this post

Thanks all .... I need to run the database for myself and see what actually happens.  I was relying on what I'd been told.

 

New Year project i think 😁


gehenna
8088 posts

Uber Geek

Moderator
Trusted
Lifetime subscriber

  #3175151 24-Dec-2023 10:18
Send private message quote this post

Does it need to run in a 64 bit version?  Not sure if it's still the case but MS used to recommend installing the 32 bit version of Office unless you had a need for the processing overhead in massive Excel sheets etc.  


Rickles

2736 posts

Uber Geek

Trusted

  #3175159 24-Dec-2023 11:01
Send private message quote this post

     >Does it need to run in a 64 bit version?  Not sure if it's still the case but MS used to recommend installing the 32 bit version of Office unless you had a need for the processing overhead in massive Excel sheets etc.<

 

I believe that there is a new, updated, computer coming.


gehenna
8088 posts

Uber Geek

Moderator
Trusted
Lifetime subscriber

  #3175175 24-Dec-2023 12:21
Send private message quote this post

I don't think that changes their advice.

 

 

 

Choose between the 64-bit or 32-bit version of Office - Microsoft Support

 

"We recommend the 32-bit version of Microsoft 365 for most users, because it's more compatible with most other applications, especially 3rd-party add-ins. However, consider the 64-bit version, especially if you're working with large blocks of information or graphics."




Rickles

2736 posts

Uber Geek

Trusted

  #3175197 24-Dec-2023 12:55
Send private message quote this post

     >I don't think that changes their advice.<

 

Very true, and what I advised.  I was merely asking on the group's behalf.


Andib
1309 posts

Uber Geek

ID Verified
Trusted

  #3175258 24-Dec-2023 20:20
Send private message quote this post

Depending on its age / who programmed the VBA, it could be utilising 16bit functions that don’t exist in the 64 bit version of office.

You’ll need to run it and see how broken it is on 64bit office, if it’s only a single function maybe try passing it into ChatGPT. I’ve had a good run on using it to convert access 97 & 2003 macros to Office365 compatible code.




Signing up for Frank Energy? Use my referral and we both get $50 credit.


Lias
5351 posts

Uber Geek

ID Verified
Trusted
Lifetime subscriber

  #3175484 25-Dec-2023 19:32
Send private message quote this post

gehenna:

 

Choose between the 64-bit or 32-bit version of Office - Microsoft Support

 

"We recommend the 32-bit version of Microsoft 365 for most users, because it's more compatible with most other applications, especially 3rd-party add-ins. However, consider the 64-bit version, especially if you're working with large blocks of information or graphics."

 

 

Search shows that blurb for that page, but the page itself doesn't. The page makes it clear that 64 bit is the default (and FWIW it has been for some time now for O365 and I'd imagine 32 bit's days are numbered)

 

"The 64-bit version of Microsoft 365 is automatically installed unless you explicitly select the 32-bit version before beginning the installation process."





I'm a geek, a gamer, a dad and an IT Professional. I have a full rack home lab, size 15 feet, an epic beard and Asperger's. I'm a bit of a Cypherpunk, who believes information wants to be free and the Net interprets censorship as damage and routes around it.


Create new topic





News and reviews »

Synology Introduces BeeStation
Posted 23-Feb-2024 14:14


New One UI 6.1 Update Brings Galaxy AI to More Galaxy Devices
Posted 23-Feb-2024 10:50


Amazon Echo Hub Available in New Zealand
Posted 23-Feb-2024 10:40


InternetNZ Releases Internet Insights 2023
Posted 20-Feb-2024 10:31


Seagate Adds 24TB IronWolf Pro Hard Drives for Multi-user Commercial and Enterprise RAID Storage Solutions
Posted 19-Feb-2024 16:54


Seagate Skyhawk AI 24TB Elevates Edge Security Capacity and Performance
Posted 9-Feb-2024 17:18


GoPro Releases Quik Desktop App for macOS and Introduces Premium+ Subscription Tier
Posted 9-Feb-2024 17:14


Ring Introduces New Ring Battery Video Doorbell Pro
Posted 9-Feb-2024 16:51


Galaxy AI Transforms the new Galaxy S24 Series
Posted 18-Jan-2024 07:00


D-Link launches AI-Powered Aquila Pro M30 Wi-Fi 6 Mesh Systems
Posted 17-Jan-2024 20:02


Newest LG 4K Lifestyle Projector Doubles as Art Objet
Posted 9-Jan-2024 15:50


More LG Smart TV Owners Set To Enjoy the Latest webOS Upgrade
Posted 9-Jan-2024 15:45


Panasonic Announces the Z95A and Z93A With Fire TV Built In
Posted 9-Jan-2024 15:30


Amazon Echo Pop Review
Posted 8-Jan-2024 14:22


Samsung Tab S9 FE Review
Posted 17-Dec-2023 08:26









Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.







GoodSync is the easiest file sync and backup for Windows and Mac