Allow me to preface this by saying I am developing this all on a remote desktop so I am hoping that has nothing to do with it.
I am trying to write my own database version checker/updater and I reached the point where I am trying to get the version number from the other database.
This is how I planned to check
but upon running it, that second line produces a 3734 runtime error.Code:Set dbMain = dao.OpenDatabase("C:\TestFolder\TestDB.mdb", , True) strMainVer = dbMain!Modules!VersionFunctions.Lines(4, 1)
What am I doing wrong? Appreciate any help.
My idea is to have the version number commented inside of a module called "VersionFunctions" and to check that version number against the current one.
If they aren't the same then it prompts for update and will run a query to copy and replace all the forms and modules.
It's a bit of an R&D/Learning project.
Thanks for any help!