I havn't used an ADODC object before, so i don't know what the property is that points to the actual database file.

If it was 'DatabaseName' (like a data object) then i would use the following in the form_load event.

VB Code:
  1. ADODC1.DatabaseName = app.path & "\MyFile.mdb"

I just did the msgbox thing so you'd get an idea of what app.path returned, sorry if it confused you.