Upgrading from 2007 to 365. Need some guidance

[Joseppy]

I have a small system with about 30 tables, 45 querys, 15 reports, and 50 forms (a good portion of the forms have code builder in them). I'm upgrading from Access 2007 to Access 365. I have another small system with no code builder and it runs just fine.

Is there a guide somewhere to get me started? I'm getting compile errors on declaring functions. Are those on functions that no longer exist?

[CJ_London]

some examples of the compile errors would help. Functions don't normally cease to exist.

If converting from 32bit Access to 64bit Access then you will need to make changes to your API function calls - adding in ptrSafe and changing Longs to LongPtrs where required. See this link for some guidance
https://codekabinett.com/rdumps.php?...ion-vba-64-bit

[ssanfu]

@Joseppy,
Welcome to the forum.

I have to say I am confused as to why you think the Code Builder (aka Expression Builder) has anything to do with the errors in the conversion. AFAIK, since A95 there has been an Expression Builder available. Not sure about Access 2 - never had it.
The Expression Builder box just helps you build expressions more quickly and accurately, with smart tools and context-sensitive information.

Is the dB an accdb or a mdb? You shouldn't be having problems moving from A1007 to A365.... unless, as Ajax said, you are converting from 32 bit to 64 bit.


Maybe post your dB for analysis???

[Joseppy]

I think you hit the nail on the head. The errors were showing 32 to 64 bit. I will check out the link and see if I have any more issues. Thanks for the help!

[Joseppy]

I didn't think the code buiulder was causing the problem. Just the fact that I had quite a bit of code that I added. I am getting errors about 32 to 64 bit conversion. I will followup with the link Ajaz indicated. Thanks for responding.

[Joseppy]

I looked at the link you suggested and most of my system is now working. Have a few other issues to address yet. Thanks for your help.