Need to store a number in ACCDE file A that can be accessed by ACCDE file B without opening A
Posted on 2013-12-17
I'm trying to find a way to store a number (just an integer) in ACCDE file A in such a way that ACCDE file B can check the number in A without opening A. I've been trying to do this using custom file properties, but I've been unsuccessful so far. Please take it for granted that I can't use tables.
The bigger picture: I split my MS Access programs into frontends and backends, and I've read that it's best for each user to have their own copy of the frontend to minimize risks of corruption. To make it easier to distribute the frontend when I make changes, I am writing a module that, when run in the user copies of the frontends, will check the frontend to see if it is the current version by comparing its version number (stored as a file property or whatever) to the version number of the master copy of the frontend (which will reside in a known location.
I hope I explained well enough for a start. Thanks in advance for the help!