Can't find the name 'CurrentDb' you entered in the expression
I have an application I am trying to deploy,
I have created a startup script to load the compiled MDE Access application, Access runtime and the tables.
I have run the startup on three of my computers and it loads and runs.
I have deleted the application and tables from one pc ant=d the startup loaded the application and it ran.
I deployed it to a family's pc. it loads .
the macro looks for a file and if it cant find it asks for the file with the table.
IT finds it and loads some tables.
In the macro I have a test for the startup application title
[CurrentDb].[Properties]("AppTitle")="EULA Agreement" OpenForm
This works on all my pc's.
On my family's pc , which has never run the app before, and on a friemds pc I get the error
EULA Agreement can't find the name 'CurrentDb' you entered in the expression.
You may have specified a control that wasn't on the current object without specifying the current form or report control.
I set the flag in the Startup screen application name then change it when the EULA is read.
Even if I change it manually to skip the agreement form it still gives me the message except now it has the application name instead of EULA Agreement.
SO I am thinking that it is the reference to DBCurrent in the macro. How can I read the application name without using DBcurrent?
I tried DBEngine(0)(0).Properties("AppTitle") = "EULA Agreement" but the macro says it can't parse the expression
I used [DBEngine].[Workspaces](0).[Databases](0).[Properties]("AppTitle") = &
And I get the Error.
Can't find the name ' DBEngine ' you entered in the expression.