[AccessD] Access Data Project (ADP) and Access Runtime

Darren,
I normally run a function before I ship my database to make sure that the
adp has no connection string. I run this from the debug window:
MakeADPConnectionless
IsConnectionSet = False

You should then be able to set the connection on open of the adp.

This is the function I use to remove the current connection:

Public Function MakeADPConnectionless() As Boolean
        ' Close the connection.
        Application.CurrentProject.CloseConnection

        ' Set the connection to nothing.
        Application.CurrentProject.OpenConnection

        ' Set the flag...
        MakeADPConnectionless = True
End Function

The Shift Key won't work in runtime mode.

Anita