Northwind 2.0 fresh template startup errors on Access 365

[Charlie8585]

Bizarre issue. I'm trying to create a new Northwind 2.0 database (File > New > Northwind 2.0 dev edition (or Starter edition - same behaviour).
As soon as it loads & I hit "Enable content", the Public Function Startup() throws a Compile Error with variable OneTimeProcessing not defined. If I get past that by stopping all macros, as soon as I try to open forms etc. I get macro errors - all Compile Error: Sub or Function not defined errors.

I've tried:

• restarting PC
• Northwind 2.0 Starter (instead of Dev Edition)
• creating/saving file from Trusted Locations (Desktop, Documents, OneDrive folders)
• creating it, saving it then closing Access and reopening file
• adding containing folder to Microsoft Office Trusted Locations

None of these solve it. Northwind 1.0 Legacy works fine though.

System details below. Does anyone have any suggestions?


My system:
OS: Windows 11 Home, v10.0, build 22631
Version: Microsoft® Access® for Microsoft 365 MSO (Version 2410 Build 16.0.18129.20158) 64-bit
Tools > References:

 

[arnelgp]

the error already suggest something and i don't think the reference has got to do with it.

 

[Gasman]

Time to walk your code. Basic Debugging 101.
This is in modGlobal.

Public Sub OneTimeProcessing()

10        On Error GoTo Err_Handler

20        If Not GetSystemSetting(ssFirstTimeRun) Then
         
30            SysCmd acSysCmdSetStatus, "One-Time Processing. Please stand by."
40            DoCmd.Hourglass True

50            SetDatesToCurrent     'So new instance is working with current data.

60            SetCtrlCurrencyFormat

70            AddDataMacros

80            SaveSystemSetting ssFirstTimeRun, True

90            SysCmd acSysCmdClearStatus
100       End If

Exit_Handler:
110       DoCmd.Hourglass False
120       Exit Sub

Err_Handler:
130       clsErrorHandler.HandleError "modGlobal", "OneTimeProcessing"
140       Resume Exit_Handler
End Sub

 

[GPGeorge]

Bizarre issue. I'm trying to create a new Northwind 2.0 database (File > New > Northwind 2.0 dev edition (or Starter edition - same behaviour).
As soon as it loads & I hit "Enable content", the Public Function Startup() throws a Compile Error with variable OneTimeProcessing not defined. If I get past that by stopping all macros, as soon as I try to open forms etc. I get macro errors - all Compile Error: Sub or Function not defined errors.

I've tried:

• restarting PC
• Northwind 2.0 Starter (instead of Dev Edition)
• creating/saving file from Trusted Locations (Desktop, Documents, OneDrive folders)
• creating it, saving it then closing Access and reopening file
• adding containing folder to Microsoft Office Trusted Locations

None of these solve it. Northwind 1.0 Legacy works fine though.

System details below. Does anyone have any suggestions?


My system:
OS: Windows 11 Home, v10.0, build 22631
Version: Microsoft® Access® for Microsoft 365 MSO (Version 2410 Build 16.0.18129.20158) 64-bit
Tools > References:

View attachment 117304

Thank you for your report.

We recently delivered version 2.4 the Northwind Dev template to be processed and deployed by Microsoft. It is working its way through their process.

In the meantime, version 2.3 is the version you should get now, not 2.0, so please download a fresh copy and try again. Note: there is a bug in v2.3 that can raise input boxes when you first initialize the template. That's one of the things we fixed.

Thanks again to everyone who continues to provide feedback.

 

[thegioserg]

Thank you for your report.

We recently delivered version 2.4 the Northwind Dev template to be processed and deployed by Microsoft. It is working its way through their process.

In the meantime, version 2.3 is the version you should get now, not 2.0, so please download a fresh copy and try again. Note: there is a bug in v2.3 that can raise input boxes when you first initialize the template. That's one of the things we fixed.

Thanks again to everyone who continues to provide feedback.

I am having this problem, except I'm being pushed the 2.4 version.

 

[Gasman]

Where do you find the version?
I just created a new developer version from Templates and mine starts fine and of course had that sub.

Edit: OK, found it in the Title, it is 2.4 ?

 

[GPGeorge]

Yes, it was quietly released a few days ago.

 

[GPGeorge]

I am having this problem, except I'm being pushed the 2.4 version.

Thanks for the feedback. Try putting the newly reconstituted accdb in a Trusted Location to begin with. There is a lot of complicated setup going on in the initialization process. Having that process interrupted by not being in a Trusted Location can result in unexpected problems. I've never had that issue when I reconstitute a test version of the templates in a previously designated Trusted Location. Let us know if that helps.

 

[jdraw]

?? Is there something obvious in the Northwind Traders template that identifies the version??
I have Microsoft® Access® for Microsoft 365 MSO (Version 2411 Build 16.0.18227.20082) 64-bit with automatic updates.
Just used the NW Developer Template and everything is referencing 2.0??
Is there a direct link to 2.3 or 2.4?

 

[tvanstiphout]

I have seen this behavior as well, if the db was saved to a non-trusted location. For me it helped to decompile the application. Search online for "Access Decompile" and you will find plenty of leads on how to do that.

 

[tvanstiphout]

?? Is there something obvious in the Northwind Traders template that identifies the version??
I have Microsoft® Access® for Microsoft 365 MSO (Version 2411 Build 16.0.18227.20082) 64-bit with automatic updates.
Just used the NW Developer Template and everything is referencing 2.0??
Is there a direct link to 2.3 or 2.4?

The version number is displayed in the application title bar, and is also a constant in modGlobal.

 

[Gasman]

?? Is there something obvious in the Northwind Traders template that identifies the version??
I have Microsoft® Access® for Microsoft 365 MSO (Version 2411 Build 16.0.18227.20082) 64-bit with automatic updates.
Just used the NW Developer Template and everything is referencing 2.0??
Is there a direct link to 2.3 or 2.4?

Check the title?

 

[GPGeorge]

?? Is there something obvious in the Northwind Traders template that identifies the version??
I have Microsoft® Access® for Microsoft 365 MSO (Version 2411 Build 16.0.18227.20082) 64-bit with automatic updates.
Just used the NW Developer Template and everything is referencing 2.0??
Is there a direct link to 2.3 or 2.4?

If you previously downloaded the template, Access may not overwrite it, apparently. Tom vS is more up-to-date on how that works.

Did you download it from the website or from inside Access?

 

[jdraw]

Tom/Paul/George,

??My title shows 2.0
Here is the start of modStartup

Option Compare Database
Option Explicit

Public Const g_strAppName As String = "Northwind Traders 2.0 Developer Edition"
Public Const g_dtNorthwindInception As Date = "11/01/2022"

Public g_dbApp          As DAO.Database
Public g_UserID         As Long

There is no version or similar in modGlobal.

George, I just used the template at the top of my Access homepage.


Do you have a link for the website?

 

[GPGeorge]

Tom/Paul/George,

??My title shows 2.0
Here is the start of modStartup

Option Compare Database
Option Explicit

Public Const g_strAppName As String = "Northwind Traders 2.0 Developer Edition"
Public Const g_dtNorthwindInception As Date = "11/01/2022"

Public g_dbApp          As DAO.Database
Public g_UserID         As Long

There is no version or similar in modGlobal.

George, I just used the template at the top of my Access homepage.

View attachment 117411
Do you have a link for the website?

Featured Access templates - Microsoft Support

Analyze and store large amounts of information, and manage data more efficiently with Access database templates available for download.

support.microsoft.com

 

[jdraw]

Thank you George. New database shows 2.4! I have bookmarked link for reference.

 

[GPGeorge]

Thank you George. New database shows 2.4! I have bookmarked link for reference.

As before, please don't hesitate to share any problems or bugs and ideas for improvement.

 

[thegioserg]

Thanks for the feedback. Try putting the newly reconstituted accdb in a Trusted Location to begin with. There is a lot of complicated setup going on in the initialization process. Having that process interrupted by not being in a Trusted Location can result in unexpected problems. I've never had that issue when I reconstitute a test version of the templates in a previously designated Trusted Location. Let us know if that helps.

Putting it in a trusted location did the trick! Now, I have to figure out why the custom ribbon isn’t showing… It’s just showing the standard ribbon.

 

[GPGeorge]

Putting it in a trusted location did the trick! Now, I have to figure out why the custom ribbon isn’t showing… It’s just showing the standard ribbon.

I see that it isn't in the version I have either. We need to follow up.

 

[Gasman]

Thank you George. New database shows 2.4! I have bookmarked link for reference.

I just created a new DB with the template. My previous version is 2.3.