PDA

View Full Version : [SOLVED:] Need help with illogical issue



Kicker
08-20-2018, 12:04 PM
background:

I have created multiple Access databases for a local hobby club.
There are thousands of lines of VBA code
These programs are individually installed on 10 computers and have been working perfectly for several years.
They are written in MS Access 365
Each computer is a 64-bit system running Windows 10


Issue:

We just added a new computer to the mix.
It has a 64-bit process
It is running Windows 10
Non of the applications will run


Error Message:

There is no error message number
The message box tells me to "update the program to run on a 64-bit processor"


We have looked for and tried several things, but to no success.

Any ideas what I can try? Any ideas 'why' this is happening?

OBP
08-20-2018, 03:47 PM
kicker, have we spoken before, your id seems familiar?
Does Access run?
Do any databases open?
Can you create a new database that works?
Can you import the objects from the problem databases in to a new database?

I am going to bed now as it is 23.46 here in the UK, so I will talk to you tomorrow.

Kicker
08-21-2018, 04:01 PM
Yes I believe we have spoken before. I'm going to mark this solved because I found the problem which I hate to admit.
We've been working with Office 365 - Access. Everything has been working great until we bought a new computer. Office 365 was installed as 64-bit. I discovered that the other installations were 32-bit. The VBA had some declare statements only valid in 32-bit.

Fixed the code and it works.

Thanks