[AccessD] Back from SQL Server

[James Button]

I would first check if the problem version is x64 office in an x64 OS
environment, with the OK ones being 32 bit office in an X64 OS environment.
If so, then  it would probably be tat you have to make the app work within 32
and 64 bit office !

After that , first thing I'd try - 
Modify a bit of the code as simple as replicating a variable assignment, then
close and reopen -
Hoping that the 'recompile' will have dealt with the problem.
You can then re-edit removing the added line, close and reopen.

JimB

-----Original Message-----
From: AccessD
<accessd-bounces+jamesbutton=blueyonder.co.uk at databaseadvisors.com> On Behalf Of
Gustav Brock via AccessD
Sent: Saturday, March 19, 2022 9:32 AM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Cc: Gustav Brock <gustav at cactus.dk>
Subject: Re: [AccessD] Back from SQL Server

Hi Bob


  *   All three machines are Win 10 64 bit. All are using Off 365.

.. but, I guess, two run Office 365 32-bit, and one 64-bit.

/gustav

Fra: accesspro at cox.net<mailto:accesspro at cox.net>
Sendt: 19. marts 2022 01:34
Til: 'Access Developers discussion and problem
solving'<mailto:accessd at databaseadvisors.com>
Emne: Re: [AccessD] Back from SQL Server



My project to rid an old app of SQL Server is going well.
Thanks for all who responded.
Once I had all local tables, the Access file compacted without a problem and
runs fine. Which was the objective. I just need to get him to back up.
An odd issue cropped up when testing.
When run on his desktop and on my home machine, starts right up.
When run on the laptop, I get the following error message:
Compile error:

The code in this project must be updated for use on 64-bit
systems. Please review and update Declare statements and then
mark them with the PtrSafe attribute.

The solution seems to be pretty simple. But it is weird that I receive this
only on the laptop.
All three machines are Win 10 64 bit. All are using Off 365.
Has anyone run into this? I would rather not fiddle w the code..

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