Forum Discussion

GhostPepper's avatar
GhostPepper
Copper Contributor
Jul 29, 2025

Access Northwind Dev Ed - Error GetRandomPkValue

Just downloaded the newest MS Access and selected a new Northwind Dev Ed as the first DB to create.

It fails to open due to an error in the code as it searched for a non existing function GetRandomPkValue...

The purpose of the missing function is to return a random primary key value by passing in the variables for a query name and a field name and then it should return a "random" numerical ID from those possible based upon the passed in variables...

My question is, Is the new Northwind Dev designed to fail on purpose or did I manage to download a corrupted incomplete version or???

3 Replies

  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor

    A lot of people have reported problems with the currently available template. 

    Others don't seem to have the same issue.

    Make sure you download and instantiate the accdb in a Trusted Location.

    We have asked Microsoft to replace the current version with an updated version supplied to them some time ago. I hope that occurs soon. 

    To answer your final question, though, of course the failure was not done on purpose. 

Resources